Computer Support Forum

Excel Order Form to Website

Question: Excel Order Form to Website

I am trying to put a simple order form on my website. I have the table with item name, price, quantity field set up in Excel but I am having problems making it functional in Frontpage. I can save the Excel file as an HTML but people who don't have Excel can only view and not interact with the table. The only other way it seems is to manually put each line into the form (but there are a lot of items). Is there a way to use Access and then couple it with Frontpage?
Thanks for any help.

Relevance 100%
Preferred Solution: Excel Order Form to Website

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Excel Order Form to Website

salenbailey said:

I am trying to put a simple order form on my website. I have the table with item name, price, quantity field set up in Excel but I am having problems making it functional in Frontpage. I can save the Excel file as an HTML but people who don't have Excel can only view and not interact with the table. The only other way it seems is to manually put each line into the form (but there are a lot of items). Is there a way to use Access and then couple it with Frontpage?
.Click to expand...

Hi and welcome to the forum...

Why not just use a simple HTML form ?
YOu already know that using Excel not everybody is going to be able to use your form. And as for the Access bit. I would say no. You can download many simple HTML forms from the net which are customisable..

7 more replies
Relevance 80.36%

Hi can anyone help me, I've been trying to do a order form in word 2002 so that customers can download this orderform from my site and email me it along with an image they choose to be used as reference for a portrait painting.The problem I'm having, the form looks great and has everything I need on but I can't seem to get it to be user editable so people can tick certain boxes, I have the boxes on the form but when I try and click as a customer would it just turns the whole of that field highlighted and doesn't put a dot in the tickable box. What am I doing wrong and does anyone know a way to do this. I think I've only got it a readable file and don't know how to unlock it to allow editing in the places that need it.Your hopefullyPhilip

Answer:Creating a Order form for my website

I think you need to go to FILE > SAVE AS WEB PAGE, then upload the web page to your website and see if it works.Charence

4 more replies
Relevance 76.26%

Hello,I have a list of ingredients that I would like to develop a user form in VBA to allow the customer to select from a series of ingredients then it calculates the price at the end once you hit Order. Here is a list of the ingredients, I will not include the prices for each as they could be anything really. More specifically I want to assign the macro to a Button to prompt the input of the order in the user form. The follow ingredients sections should be listed with radio buttons. Once selected the user hits submit which calculates the total and gives a summary of the final order.MeatsBeefBlack BeanBuffalo ChickenGrilled ChickenSoy BurgerTurkeyVeggie BurgerCheese American CheeseCheddar CheeseMozzarella CheesPepper JackToppings JalapenosLettuceMushroomsOnionsPeppersPicklesSpinachTomatoBaconBreadGluten Free BunMultigrain BunOnion RollPotato RollRamen BunWhole Wheat Bunmessage edited by phatguy85

Answer:How to set up VBA form in Excel to input food order?

I have developed a simple form with only meats on it, you can select which meats you want and hit the calculate button and it will give you the price.I had to use another sheet to itemize the product and cost as per below
1 Meats Cost Cheese Cost
2 Beef £5 American Cheese £1
3 Black Bean £2 Cheddar Cheese £2
4 Buffalo Chicken £15 Mozzarella Chees £4
5 Grilled Chicken £15 Pepper Jack £5
6 Soy Burger £1
7 Turkey £22
8 Veggie Burger £10
I would personally split the catagories into different frames on your form, that way you can run the code which will take the values from each checkbox within each frame and check against the relevant list within the sheet and get the associated cost.I cannot upload the file here so send me a PM with you email address and I can send it through, alternatively you will need to do the followingInsert a form - name it 'frmorder'place a frame on the form - name it 'Fram1'Place 7 checkboxes within the frame - named 'Checkbox1' - 'Checkbox7'Place a command button on the form - named 'CommandButton1'Place a label on the form - named 'Label1'Paste the following code within the forms moduleDim SaleCost As Currency

Private Sub UserForm_Activate()
i = 0
SaleCost = 0

For Each bcell In Sheets("Sheet2").Range("A2", Range("A" & Rows.Count).End(xlUp))
FrmOrder.Fram... Read more

4 more replies
Relevance 74.62%


I was hoping someone could help me with creating an order form in excel that would then update the inventory (the main reason for this is to update the inventory rather than actually store any data).

Order for Black Collar with the name jamie - when clicking on proceed it would update the inventory minus 1 black strap and letter J, A, M, I, E

The inventory would consists of Collars, Letter and Charms.
This is where i am having real difficulty and can't figure it out as the order could be for different collar style or colors, there are 2 different letter styles (silver and colored) so the order form would need to know what set of letters to update the quantity against...

I have attached the actual excel sheet i was going to use so you can see exactly what i have got so far but it is almost an empty shell at the moment as i got stuck with this order form/updating inventory part.

As you will see when you open the excel sheet, i would like to be able use the 'Order Form' button to process the order that would then minus the QTY against the inventory.

When you click the 'Inventory' button there are 3 sections (Collars, Letters, Charms) this is where i would like the numbers to update from the 'Order Form'

I hope someone is able to help, i know its a lot to ask.

I have put description examples on the order form to try and help you understand what i am trying to achieve.


Answer:Excel Guru Needed - Help with order form that will update an inventory

It's over my head, but you might have some luck at the MrExcel forum.

5 more replies
Relevance 65.19%

Hello I found an answer to this question but it was specific to his form. I have several Excel Logs (Tables) that contain information that is also entered into a separate form. Some forms are in excel and some are in word. I would like to hit a button that transfers a row of data to the form so i only have t enter data once. The forms will have additional information that will be entered. The forms are saved as a specific file type and are also printed so the answer that i found on this site may work but it puts the data into a different spread sheet in the same workbook and i need to send the data to a new workbook and in one case to a word doc. Can someone help me out. I have attached a couple examples of what i currently do.

Thanks for the help

Answer:Solved: Populate Excel Form and Word Form from Excel Table

16 more replies
Relevance 58.22%

I'm needing assistance on a problem I'm having with an order form in excel. I have attached it.

When you click to select another shirt in C7 to C17 it seems that the prices for items after apparel item F1514137 and to the end at MUN710 are not loading prices when you select the size. After selecting the size the price should populate.

Also, I'm not sure why the colors are not showing up for style #F2060 and why the sizes are not showing up for style #209037. I thought it was because validation was not set up but unfortunately when you do it cause all the other apparel items to have that same size.

I had a wonderful opportunity for one of the skilled excel guys on this site to contruct the order form and have requested further assistance but I'm sure he's very busy and do not want to wearout my welcome.

Edited to remove attachment. EAFiedler

Answer:Help with order form

12 more replies
Relevance 58.22%
Question: Order form

Ok this is a bit funny i guess
I play Anarchy online a Lot. In an Organization Called the Mockers. be basic do orders for people. atm we have people place orders with us on the message board. what i want to set up is some kind of order form that does this

Takes order <easy enough in HTML>
enters order into a database. something like Lvl of the item name of person iteam time order was placed.

Have it so that org members can check database and view it in grouping of anything from lvl of iteam to time placed.

Form i can do easy. i just have no database experience. what kind of language should i use to create a database that can do this. or ap rogram <freeware or cheap>. Our Server can suport PHP/PERL

More replies
Relevance 57.81%

Unable to convert Word form to Excel form. Tried screenshot of Word form, pasted to Excel sheet and filled-up by text but the text itself always mis-arrange.Kindly help me please...

Answer:Convert Word form to Excel form

Rather my cherry picking and copying a few how to... suggest you follow the results here:'s a google list found using:convert excel document to wordas the search term...

2 more replies
Relevance 57.4%
Question: order form (cart?)

I am building a website for a company and I need a way for customers to select and order their products.
Does anybody know of a "simple" way to do this?

No, I don't know Perl.

If not what's the simplest? hehe
(I gotta maintain this site)

They are a big company but only sell a half dozen products.


Answer:order form (cart?)

Hi, AZ

Re: shopping cart...

If you want to explore the possible coding behind it you might like to look at the following:

I also know there are applications around that you can use without having to learn code:

Short of that, the choices are going to involve a server-side language. Perl isn't that hard to learn. Well, I think it's a doddle compared to Java. The only other thing to add is: if the customers are ordering online, make sure you've considered security. A lot of webspace providers cater for well as providing shopping cart solutions and support.

Hope this is of some help.
Joyous Monkey

2 more replies
Relevance 57.4%
Relevance 56.99%

Hi everyone!
Im buliding a website for a client, and she has asked me to bulid a page which features a order form with check boxes, drop down boxes etc, with intergreation to paypal. So when the customer chooses their items, the amount is calcuted and then they pay through paypal.
Is there a service which provdies an customiable form with paypal that is free? (and prefabably that you can embedded code too) She cant afford a paid form yet as the bussiness has just started.
I also understand html, so is there a form template i can modify? If the first option is not possible.
Any questions with my query, just ask!
Thanks for the help!


More replies
Relevance 56.99%

Hello allHow would I go about enabling automatic price calculation on an order form ? For example, if a customer were to select 3 of a certain item, and 2 of another item, and just 1 of a third item, how can I get it to sub-total each individual item and then give a grand total at the bottom ?I guess that it would be javascript of some kind or maybe there is a template I could use. I don`t need to have the form sent to me after it is totalled as it will be printed out and sent to me by the customer. It is just for the customers information. T.I.A. Andy

Answer:Order form price calculator

click hereclick hereI did these as examlpes some months ago for another forum member, who has since modified one of them to suit their requirements.Either view the page source and save it or save the web page using the File, Save As option.Don't as me why I called them quote1.html and quoteB.html. I must have had my 1s and Bs crossed that day ;o)Anyway, although the second example has a submit button on it you would need to input your own form processing code. You could just as easily put a Print JavaScript code snippet in there and change the caption on the Submit button to Print.They should give you some ideas though and adding extra items into the forms is fairly easy if you spend the time to read the underlying code. It's pretty straight forward.Hope it helps.T

4 more replies
Relevance 56.99%

I have created a form in table format. Is there a way to change the tab order from top to bottom instead of left to right?

Answer:Form in Table w/Fields - Tab Order

In Datasheet View (table format), each row represents a record. The only way that you could use the tab key to move from one record to the next would be to disable the Tab Stop property of all the controls on the subform, then set the subform's Cycle property to All Records. Bear in mind, this will prevent you from tabbing into any other field than the first field in your subform, so you'd have to manually focus (i.e., click) on a control in order to edit its data.

Why exactly do you want to do this?


3 more replies
Relevance 56.99%

I am trying to create an order form but I keep getting a message that says "Another instance of wizard is already running" and I don't know how to get back to it now so I can create the page.

Answer:frontpage 2002 order form

can you see it when you Alt+Tab??

2 more replies
Relevance 55.76%


I have just started my own PC/Mac Repair Business.

Is there any way to get a free copy to edit of the fallowing forms or do y'all have any examples that you can send to me to use as an example?

In-Shop PC/Mac Service/Repair Work Order Request Form
Onsite PC/Mac Service/Repair Work Order Request Form
Remote Support Session PC/Mac Service/Repair Work Order Request Form
Data Backup/Recovery Service Request Form/Agreement
Diagnostic and Repair Technician Checklist
Custom Desktop PC Build Service Order Request Form
Labor/Sales Invoice/Receipt Form

Can someone please help me?

More replies
Relevance 55.76%

Hi, I'm actually having an issue with the HP Support website, not really my HP product itself. I'm trying to order a Windows 7 64-bit recovery kit for my Pavilion DV7 notebook. I completed the order form and entered the model number and serial number for my notebook, but after I submit my payment information for the order, I'm receiving an error message that says "Payment form contains invalid entry". I've tried submitting this form several times today and keep receiving the same error. The warranty for my product expired back in 2012- could this be the reason that I'm unable to order the recovery kit? Sorry if this is the incorrect forum to post this question- I wasn't sure how else to contact technical support about this.

More replies
Relevance 55.35%

Hello again,

I have a word doc that has a form in it. The form may have any number of fields (boxes) to type text answers into, or be a drop down list to select an answer from. I need an excel macro that extracts all data from the form, but with every five fields starting a new row in excel. So all data from the form will appear within 5 columns in an excel spreadsheet.

field 1 field 2 field 3 field 4 field 5
field 6 field 7 field 8 field 9 field 10

Is that possible? I have had no luck to do it myself.

Sample form attached, thank you

Answer:Solved: Excel macro to extract Word form data into Excel

7 more replies
Relevance 52.89%

Hi Folks,
I am hoping that someone in here can shed some light on an issue for me.
I am developing an e-commere site which is pretty comprehensive.
The site takes the customer order, verifies the payment through the payment gateway and creates an order entry in the "New Orders" folder.

I am also running a sales order management package on a local server which has an xml import facility.

I have designed the customer order report on the website to match the xml import schema in the SOP package and as far as I can tell, this should work fine.

My question is, how do I get the data from one to the other?

I would like to set up a timed transfer of data, say once an hour where the webserver initiates secure contact with the SOP server and after handshaking etc transfers the new orders to the SOP system.

The webserver is a linux VPS running cpanel 11, php5 & mysql 5 and the receiving server is an AMD2+ 64 running win 2003 server sp1, advancepro SOP and Quickbooks Pro 2008 ( as the two talk directly to each other making accountancy very simple for my small organisation).

How do I get either the SOP server to initiate connection or the webserver to initiate connection? The communication needs to be bidirectional as once an order is received by the SOP systems and processed, it needs to update the clients "My Account" facility on the website with the order details, the UPS/Fed Ex tracking numbers and a link to the pdf invoice retained on our systems.

I hop... Read more

More replies
Relevance 52.89%

I ordered a 'DVD - Windows 8.1 64b + Supp 2 Recovery Kit' from the HP website and it should have arrived a weeks ago. Who do I contact to resolve this issue and how?? I am looking for a phone number not the customer support webpage which is confusing and a joke. I just want to chat with an actual person

More replies
Relevance 52.48%

I am trying to build a search form for my website. I only want it to search the pages that are within my site, not anything outside of it. Does anyone have a clue how to do this???


Answer:Search Form for Website

12 more replies
Relevance 52.48%

HiTrying to avoid spamming, I want a form that visitors can complete with a free text box, their name etc and press submit to email me.Ive scoured the postings but still stuck - my site is created in DW MX and Im using easygen to make it dynamic.Is there a piece of PHP code or similar available for pasting in to my site?Cheers Steve

Answer:Email form on website

There are loads around.Heres one click herenot used it as I write my own!

4 more replies
Relevance 52.48%


I need a contact form on my website, that will send to my email address what the visitor enter in the form fields. The problem is that I can't run any php scripts.. is there a way to use some html form?

Answer:Help with contact form for my website

After searches, I found a site that offers remotely hosted contact forms, EmailMe Form™ - HTML Forms, a simple way to receive email from your website . Basically, I paste the html code in my website, and it calls the php script on their server who sends the email.

2 more replies
Relevance 52.48%

Hi there

Just wondering if there are any experts out there on this.

I have a 'contact us' form on one of my webistes -

I had someone send me a message using this form, but they used a fake email when they filled it out.

This message I believe is from someone that is very close to crossing the line for stalking, but because they sent it through this form I cannot say for sure that it was them that sent it.

The message was very threatening - both in threatening to ruin my business as well as threatening bodily harm.

So I am trying to see if there is any way of being able to trace who sent the message through this form.

Is there anyone that has any knowledge on this that could help me with this please.


Answer:Can you trace who used a php form on a website?

I personally know of 2 ways to trace it , one i'm positive will work of the second not as much
1. a court order obtained from your local prosecutor
2. a hacker

3 more replies
Relevance 52.48%


I need to find out how to set up an online query or enquirey form (i have this already made in html), then, the part i cant do - when the "send" button is pressed, the info that was entered into the form needs to be emailed to my adress, and not displayed onto the website. so if anyone knows how to do this it would be a great help.

I dont know much HTML and dont know any other coding although it doesnt have to be just html.


More replies
Relevance 52.48%

I'm looking to create a form on a website with some multiple choice questions and some name and address details which I want to be submitted to me via email.Is this just a case of writing some HTML to do this, or do you have to have a database behind it?Any good webpages with instrctions and maybe some code I can copy?

Answer:Creating a form on a website

With respect, try the Web Design forum.

4 more replies
Relevance 52.48%

Hi, I was wondering how or where I can get a code to put an application on my website, and get it emailed to me. Thanks.


Answer:Hot to add a form/application to website

8 more replies
Relevance 52.48%

I've been asked to resolve problem with website form at click hereThe form on the contact us page no longer seems to work, the page that it points to once form has sent appears on smart ftp as being on server but can't seem to find itPlease help!!!!

Answer:website form problem

The page (sendemail.php) is on the server but won't open. It's possible that php is not running on the server, or is not working for some reason. I suggest that you check with the host.

3 more replies
Relevance 52.48%

Hi, I am currently designing a website using coolpage html editor. I want to put a form on my site enabling customers to order nametapes from our company. Can anyone tell me how to start?

Answer:Creating a form on my website

11 more replies
Relevance 52.48%

Hi All,I have a website form that has been created with Dreamweaver which includes a number of compulsory fields. These have all been validated and includes one which requires a number to be entered. With the exception of the number field all fields work OK and the form can be submitted successfully to an e-mail address.The problem I have is that the number field, which is set to a maximum of 4 digits, allows text to be entered as well as numbers. I can't find a way to prevent this. Can anyone help?CheersKenHow

More replies
Relevance 52.48%

If I have the part number...., how can I order it from the Lenovo website?

Answer:How to order parts on Lenovo Website?

In U.S., Lenovo parts are distributed by IBM:

2 more replies
Relevance 52.48%

I have the same issue, but on steroids.  I have an Essentials G550 with a serial number that is unknown to the Lenovo parts system and I cannot get past that page.  Yesterday I attempted to explain that to support on the phone but they didn't seem to understand.  So I attempted to use the chat line and they didn't want to help and told me to go to the parts site.... which I had just finished telling them I couldn't get into.  So far I am not pleased at all with Lenovo Support.  Not at all.  I will monitor this thread to find out if anyone here cares about customer service - I am convinced that chat and telephone help is not worth the trouble.


Go to Solution.

Answer:Re: How to order parts on Lenovo Website?

Is this the screen you started with: forum is for T-series ThinkPads. I am moving this to the correct forum where someone else may have more info.

2 more replies
Relevance 52.48%

I was trying to log into a work from home website. They had specified that I use Internet Explorer but I couldn't log in until I had added that website to IE's compatibility view setting. Then it worked O.K.
My question is, WHY????

Answer:Had to use Compatibility View in order to use a website.

Hi there

Probably because the site was still using FLASH. There are a lot of new ways (and more secure too) of displaying web sites, as well as the sites themselves using different coding techniques.

A lot of older sites or sites developed using earlier coding standards and programs won't display properly on IE11 but will when using Compatibility mode as this mode will still read and execute older coding and protocols.

Also note that some sites like Banks etc which might be capable of running the new software (No Flash, HTML 5, CSS etc) might also check for specific browser versions -- IE11 might not yet be added to their list even though the site has been updated. Running in compatibility mode will "poodlefake" the site as well into thinking you are running IE10.

Any Furniture restorers or visitors to antique auction rooms will understand the expression "Poodlefake". !!!!



2 more replies
Relevance 52.07%

Problem creating a website form. I created a form on my website which works fine except that it sends the resulting email to the Outbox in Outlook Express and pops-up a sequence of two security warnings. Please can someone tell me how to send the form straight to the recipient from the website (by-passing OE) and how to stop the two pop-up warnings? The form is of the type: form name=?form? method=?post? action=?mailto:[email protected]?SUBJECT=Brochure Request? enctype=?text/plain?> Regards Awestruck

More replies
Relevance 52.07%

In sending an email to an [email protected] address we can insert an attachment, picture or text. Is it possible to put an attachment into a website contact form? There is no obvious provision for an attachment.

Answer:Put an attachment onto a website contact form

I'm sure you can do it. I am not entierly sure how to do it but use

2 more replies
Relevance 52.07%

how can you make a website login for like the one on pca with the email address and the password....i no how to make the fields but am a bit confused on how u send it to what server/computer and howi want to make a website with a login screen can anyone point me in the rite direction?

Answer:How do you make a website login form

web design forum?johnny

2 more replies
Relevance 52.07%

I have some webspace with a hosting company for one site built using frontpage and using a form to send results back to my email with results of customers orders, this works fine. I wanted another site to make paypal payment pages for a flash site I have so again I bought a domain name and used the add on domain feature at my web hosting company, I designed a front index page and individual payment pages that are going to be linked to my flash site. Right now for the problem for some reason when I tried to test it and filled out the order form and click submit it flashes on a username and password box up. I don't know why this is, has completly baffled me and my hosting company. Anyone have any ideas why this would happen, the form on my other site as I say done the exact same way works ok. Phil

Answer:Problem with Frontpage form on my new website

is it the standard Windows server challenge - the type you see when you want to logon to a network?You'll need to explain your system in more detail. As I understand it you have a site that's entirely Flash, and you want to send customer's payments from it to your PayPal account, is that right? For some reason you've bought a special domain name and set up yet another site to do this - why have you done that?It sounds to me as if the form is submitting itself to a different server directory - one on which you don't have write permissions, so the server is issuing what we used to call an NT challenge, the type you get when you logon to a network workgroup.Perhaps if you could give me a step-by-step explanation I'll be able to sort this out for you.

2 more replies
Relevance 52.07%

I want to download qbasic from this website but I cant tell me how to do that and from where?

Answer:Where to dwonload qbasic form this website?

Did you try using google?, there's no way you're John Cena. He's smart enough to know how to do a web search. And he wouldn't be posting in the XP forum if he was running Vista.

3 more replies
Relevance 52.07%

Having a fairly simple website for work containing a contact form, with the proliferation of mobiles and increasing views on our site, I've designed a simple contact form for mobile users and am asking for opinions on usability from other mobile devices, I've used my galaxy tab but don't have access to numerous other mobiles.
The form is here
the rest of the mobile site is this one
I am aware the reest of the site doesn't yet point to the reminder form , I want opinions before it goes live.

Answer:Mobile website Contact form

don't know what happened to the links there
links are

3 more replies
Relevance 52.07%


Im trying to submit a form without having to click things?

The form is something like;

HTML Code:
<table class="alertwarning" cellspacing="3" width="100%"> <tr> <td><label for="findLocationControl_tristateLocationControl_locationAmbiguous_SelectOptionDropDown" id="findLocationControl_tristateLocationControl_locationAmbiguous_labelPossibleLocations" class="txtseven">Select from possible options for <b>"ts254pd/"</b></label></td> </tr> <tr> <td align="left"><select name="findLocationControl$tristateLocationControl$locationAmbiguous$SelectOptionDropDown" id="findLocationControl_tristateLocationControl_locationAmbiguous_SelectOptionDropDown" style="width:450px"> <option selected="selected" value="unrefined">---- Please select from the following options ----</option> <option value="0">1 Darwin Grove, Hartlepool, TS254PD</option> <option value="1">2 Darwin Grove, Hartlepool, TS254PD</option> <option value="2">3 Darwin Grove, Hartlepool, TS254PD</option> <option value="3">4 Darwin Grove, Hartlepool, TS254PD</option> <option value="4">5 Darwin Grove, Hartlepool, TS254PD</option> <option value=&... Read more

Answer:Does anyone know how to submit a form on aspx website?

Clicking is the way we normally initiate a process. Other ways are automatically at start-up or using Task Scheduler. How do you want to submit it? Also, what's the difference between a "form" and a "send form"?

1 more replies
Relevance 52.07%

So a couple days ago my desktop started acting weird, wouldn't respond to my key presses as much and then after about ten minutes of firefox use I could no longer click or type in forms (Such as the address bar) and I have to restart firefox. Now I see that the computer only goes to some sites but not many, not even google. I have to post this on my laptop it has gotten so bad. I have ran scanners that removed several items but still no good. Here is my log. Thanks for any help!Logfile of Trend Micro HijackThis v2.0.2Scan saved at 7:48:44 PM, on 7/17/2008Platform: Windows XP SP2 (WinNT 5.01.2600)MSIE: Internet Explorer v7.00 (7.00.6000.20733)Boot mode: NormalRunning processes:E:\WINDOWS\System32\smss.exeE:\WINDOWS\system32\winlogon.exeE:\WINDOWS\system32\services.exeE:\WINDOWS\system32\lsass.exeE:\WINDOWS\system32\Ati2evxx.exeE:\WINDOWS\system32\svchost.exeE:\WINDOWS\System32\svchost.exeE:\Program Files\Lavasoft\Ad-Aware 2007\aawservice.exeE:\WINDOWS\system32\spoolsv.exeE:\Program Files\Common Files\Apple\Mobile Device Support\bin\AppleMobileDeviceService.exeE:\Program Files\Bonjour\mDNSResponder.exeE:\Program Files\Webroot\Spy Sweeper\SpySweeper.exeE:\Program Files\iPod\bin\iPodService.exeE:\WINDOWS\System32\svchost.exeE:\WINDOWS&... Read more

Answer:Odd Form Problems And Website Issues

Hello kdin200x and welcome to BC. Let's see what we can find. Follow the steps below in order:Before running a new scan let's clean out the temporary folders. Download ATF Cleaner to your Desktop.Double-click ATF-Cleaner.exe to run the program.Click Select All found at the bottom of the list.Click the Empty Selected button.If you use Firefox browser, do this also:Click Firefox at the top and choose Select All from the list.Click the Empty Selected button.NOTE : If you would like to keep your saved passwords, please click No at the prompt.If you use Opera browser, do this also:Click Opera at the top and choose Select All from the list.NOTE : If you would like to keep your saved passwords, please click No at the prompt.Close ALL Internet browsers (very important).Click the Empty Selected button.Click Exit on the Main menu to close the program.Now download OTScanIt from here or here to your Desktop and double-click on it to extract the files. It will create a folder named OTScanIt on your desktop.Note: You must be logged on to the system with an account that has Administrator privileges to run this program.Close ALL OTHER PROGRAMS.Open the OTScanIt folder and double-click on OTScanIt.exe to start the program (if you are running on Vista then right-click the program and choose Run as Administrator).
In the Drivers section click on Non-Microsoft.Under Additional Scans click the checkboxes in front of the following items to select them:Reg - BotCheck
File - Additional Fold... Read more

1 more replies
Relevance 52.07%

Problem creating a website form.I created a form on my website which works fine except that it sends the resulting email to the Outbox in Outlook Express and pops-up a sequence of two security warnings. Please can someone tell me how to send the form straight to the recipient from the website (by-passing OE) and how to stop the two pop-up warnings? The form is of the type: form name=?form? method=?post? action=?mailto:[email protected]?SUBJECT=Brochure Request? enctype=?text/plain?>RegardsAwestruck

Answer:Problem creating a website form.

Sorry - can't help with that one, but you may get a better respons if you post to the web design forum. Cheers :-)

2 more replies
Relevance 52.07%

If you know about security in website and computer then tell me how to secure Website from Malware Attack. And what is the role of Google Webmaster in security purpose?

More replies
Relevance 52.07%

Where I order math software for to prepare? If anyone prepares me when s/he can contact me. I will give them my math solver list and detail and we can discuss them all detail.
you can look for example: or I want to order like this software someone can build it.

More replies
Relevance 52.07%

I work for the state and I am currently lookin for a good website that we can get an account with and go to thats reliable and that i can order tools and items from.

Right now we currently need a spindle of 1000ft Cat5e Non Plenum STRANDED and about 200 RJ-45 connecters, if anyone could help it would be great.

Answer:good website to order items for business?

I really like dealing with CDW but for true networking/cabling needs I have to pimp a business my friend works for l-com , check them out at

GREAT company, awesome prices and all they do is deal with telecomunication firms, networkin etc... mostly cabling/connectors etc.. Anything from phone lines to fiber stuff

2 more replies
Relevance 52.07%

Hey guys, newbie here.

I have a friend that says Apple Fraud Prevention contacted him and claims that an Ipod Order was made over the Internet on the Apple website from his IP address using his name, but that somebody else's credit card was used.

He knows nothing about this. He doesn't even have an Apple account.

He thinks that his wireless internet was hijacked by some neighbor kids and they somehow used his IP to order an Ipod using his name but somebody else's credit card.

Is this possible?

How can he prove that somebody hijacked his IP? I know you have to log into the Apple website to order an Ipod, so is this even possible with a hijacked IP address?

Seems like the data would be returned to his computer (the real IP address) and that the hijackers could never complete the Order.

Thanks in advance!

Answer:IP Address hijacked/Order on website made

7 more replies
Relevance 51.25%

I have this online form of sorts that has a bunch of Site names in the first column and then a box next to it that needs the site code that matches the name. I have the master list in Excel which is a good 1000 sites with their codes. Is there any software that will look at the text then search a list and plug in the number or is that only possible with some kind of cgi or sql thing.

Answer:Website form filler, not for passwords and stuff

I don't know of any software that will do this for you, but it may be possible to write an Excel macro to do it??

You'd have to elaborate on what you're doing for us to help you further. What's a "site code"? Is it an arbitrary code for the website? Its IP address?

2 more replies
Relevance 51.25%

I would appreciate it very much if someone could recommend a program to me that will send a fax automatically after someone fills out a form/makes selections on my site.

More replies
Relevance 51.25%

Hi all.

I am using WebEasy Professional 6 to design my website. I have inserted a form on my 'contact us' where clients can submit comments, however these comments display in html format when I view it in my inbox (Microsoft Outlook). Does anyone have any suggestions to correct this? Thanks!

Answer:Form on website displaying comments in html

Greetings, BexBomb.

Sounds like you've got something missing, most likely a bracket. Look for code similar to this:

<form>yada yada</form

Notice the missing > after the second "form".

If you can't find the culprit, post the address and I'll take a look at it, or you can validate the page at which should show any HTML mistakes on the page.

3 more replies
Relevance 51.25%

Can it be done? insert an image into a message form. Attached
By deezalboy

Answer:Insert an image into a website message form

Well, not if the message doesn't allow html or bbcode. I'm guessing from the screenshot that the box only allows text. The best you can do is ascii art (assuming it aligns properly) or text smilies.

3 more replies
Relevance 51.25%

Hey guys - got an issue I'm totally stumped with:

I have a customer I support on Office 365 and have done for the last 6-8 months. Their website is less than spectacular but does include a booking form for enquires (car rental company)

I have no control over the website but am talking to the guy who has access to the site and domain panel for the company.

From my understanding, when a customer fills in the form and clicks submit, the web server hosting the site and form sends out a confirmation email to the customer and to the [email protected] email address for the company - for this to work the domain has to allow both the website and the office 365 email address to send emails - to allow this to work, this needs an TXT/SPF record allowing both servers to send email using the domain (please correct me if this is wrong!)

We had the same issue a few months ago, in the end we created an SPF/TXT record that combined the webserver and the 365 exchange server, it took a few hours to finalize but it did seem to resolve the issue.

For some reason in the last few days, the form has stopped working again, the customer doesn't receive a confirmation email, nor does the [email protected] address - the only thing I can thing of is that the domain is not allowing the webserver to send email or something to that nature.

I have submitted test bookings which have gone nowhere and had no response to any address, however if I just send emails to the [email pro... Read more

More replies
Relevance 51.25%

I would like to buy an inspiron 13 7000 I7 ram 8/12 from the dell's official websites but there is no link to buy them in the south african dell website. I have called, i have sent already other 2 mail but nothing response. CAN YOU PLEASE HELP ME OR I HAVE TO CHOOSE AN OTHER BRAND?

Answer:I need help to order Inspiron 13 7000 in the south african website

If the model isn't listed, it's not for sale in that market.  And if it's not, there's no support for it if you import one yourself - bear that in mind.

1 more replies
Relevance 50.84%


I got a small probplem,

After I put the all details, and the visa details, i recived a masseage said: ((Credit card validation failed. Please check your payment data)), I tried 4 diffrent Visas
any body can help me?

My laptop is Satellite A200-1GB.

I'm trying to buy from this website.

I live in Saudi Arabia

Thank you

Answer:Cannot order the Recovery disk from media online shope website

> ((Credit card validation failed. Please check your payment data

This has nothing to do with the Toshiba notebook!

Possibly you credit cards are not allowed...
Contact your bank and clear this issue

11 more replies
Relevance 50.84%

We can attach a file to send an email to an email @ address, is it possible to copy and paste a file into a website contact form like in photo?

Answer:Copy and paste file into Website contact form

Not usually.

3 more replies
Relevance 50.84%

Hi All,

Just came across a wierd problem, part of my job consists of copying data from our reports website. This normally a very simple processs, just cut and paste into excel(2003). But recently I've had a new section added to the reports website which format wise is exactly the same as previous ones. The problem is when I go to copy and paste into excel, it copies all of the data into one cell, instead of spreading it across the appropriate number of rows and columns.

I know this sound confusing but anyhelp would be greatly appreciated.

Due to the sensitve nature of the data I cannot re-create an example.

Answer:Excel 2003 - Pasting Website data into excel

is this info in a grid/table on the website?

2 more replies
Relevance 50.02%
Question: Excel ABC order

Ok I was wondering is there a way to sort an entire column while sorting other columns with it... I.E.

I have column A that I want in ABC order but columns B and C that go with A so I want those sorted along with A Kind of like



c 7 b
b 1 a
a 9 c
After Sorted

a 9 c
b 1 a
c 7 b


More replies
Relevance 50.02%
Question: Excel, in order!!!

I put some payment list on Excel with Due dates next to them. How can I put them in order, the closest date will be on the top? Then second closest and so forth?

I also have another question. I can't open link pages that come along with emails to my Microsoft Outlook. What could be the problem? I hate this SP2 thing. I really would like to uninstall it.

Thank you...

Answer:Excel, in order!!!

Hi osm079

To keep the data on the same lines when you sort, click the upper left block of the excel sheet location shown in Red in my diagram.

This will highlight everything on the spreadsheet.
On the Toolbar
a window will pop up with sort actions for you to choose,
click the dropdown arrow in the first field to choose what column you want to sort by then click on Ascending sorts A to Z (first to last) or Descending, sorts Z to A (last to first).

If you use the Sort Ascending or Sort Descending buttons on the Toolbar, (with the entire page selected) it will sort column A (simple sort).
If you use this method, you would want your Due Date in column A.

You can also create a practice spreadsheet by holding the ctrl button, left clicking on the Sheet tab at the bottom, drag it over to the right of the other sheet tabs and release. Name the Sheet tab Practice.

Then practice sorting away without worrying about losing your data's format.

If you have any more questions, please feel free to ask!

1 more replies
Relevance 50.02%
Question: Excel a-b-c order

I am making a spreadsheet for my daughter's wedding, with names and food choices, and just learned how to put my guests names in alphabetical order. However, how do I add more names in a-b-c order, and how do I include their food choices? ex:
M/M john Doe 1 chicken 1 fish
M/M Sam smith 2 chicken
Ms. Sally Martin 1 fish
Ok, so now I highlight the names, and put them in a b c order, but what about the food? Do I highlight those cells also when I click on sort? I have just been highlighting the names, not the food.
Also, when I get new names, how do I enter and alphabetize NEW names when I get them?

Answer:Excel a-b-c order

12 more replies
Relevance 49.61%

Some other user also posted this at: But it is in "General Discussion" forum, and maybe no one has noticed this. QUOTE BEGIN:I'm trying to make a purchase at the Lenovo US website and I keep getting this error message (The bank did not approve the charges for the credit card provided. Please verify the information provided was accurate, contact your bank or enter another form of payment) I've verified with my bank that the card is in order and there is sufficent credit to make the purchase. (I previously used the same card to make successful purchases a few months back) I even tried using another credit card but was still unsuccessful. I tried using different shipping addresses, tried using different computers, different accounts, no luck. Whats the problem here? I've called, emailed lenovo, but still no word or help.QUOTE END: In my case - very similar - I tried all the above as well. I also called my BANK - and they said no problem with the credit card, and they did not even get the "decline" in their system, so they suspect LENOVO website issue!!!

Answer:Lenovo website refuses to process Credit Card (USA) when I try to order a Thinkpad T410

Can you send me a PM with your order number?   I'll see what we can find out.

6 more replies
Relevance 49.61%

MAPI problems, sending web forms
If I fill in a form on a website, and press submit it just opens a blank email page outlook express rather than sends the information |I have already filled in. Help. Apparently it is something to do with MAPI but I have dfone a MAPI fix but no difference.

Answer:I can't submit a form on a website, it brings up a blank outlook express page

That is a problem withe the FORM on that webpage, not with your browser.
Click on View/Page Source and find <form and then type=submit.
Somewhere between those items is where it goes wrong for them.

If those people can't get it right, it is either a spoof, phishing for creditcard details, or a webdesigner that's not competent.

7 more replies
Relevance 49.61%

I made an Excel worksheet and I want to set limits to where a user is able to tab to. Ie...The user starts in A2 and presses tab to get to B2, when the user presses the tab key again I want them to be taken to tab A3. Any Ideals? Thank you in advance for your help.

Answer:Excel worksheet tab order

Do you only want them to have access to the columns A and B only?? If so, try this.. Select the range of cells that you wan them to have access cells (EX: A2:B20). Right click on one of the selected cells and Select FORMAT CELLS. Then find the "Protection Tab" and UNCHECK the box next to" Locked". Close the FORMAT CELLS box. Then we are going to protect the worksheet and/or workbook depending on whichever you wish. This method will vary depending on which version of Excel you have. If it is the 03 version, go to Tools, Protect. If it is 07+, go to the Review Tab. Once you select Protect Sheet, you should see some options or "permissions" with check boxes next to them. Here we want to DESELECT "Select Locked Cells" so that they will only be able to select the cells that we previously "unlocked".BEST OF LUCK!

2 more replies
Relevance 49.61%

I only use Microsoft Excel to create a list of my books,
So don't know much about it. I like to sort my imported booklist into 2 columns One titled author and the other the name of the book.
Then import it into Word and print it out.
However just tried with this months imported booklist and am unable to do that as the author and title are both together in Column A.
Not A and B.
As the clip I uploaded How can I change it back?

As I say I don't know a thing about Excel

More replies
Relevance 49.61%
Question: A Form in Excel

I opened a form in Excel (2007), that insert data to the worksheet.
When I close the form by one of the commands: "unload" or "close" or manualy the data disappear. What is the solution?

Answer:A Form in Excel

Can you post the VBS for the unload function ?

5 more replies
Relevance 49.61%
Question: Excel form help

I have created a purchace order form. I have a cell that has the PO number. I was wondering if there is a way to have this number automatically increase when a new purchace order form is created. so the first time I open it the PO number will bee 1000. If I open another form the PO number will automatically change to 1001. Is there a way to do this?

Answer:Excel form help

Hello there,

Yes it is entirely possible. You'll most likely need VBA for this. Can you define your problem a little more so we can get you a customized solution? Lets start with a few questions:

Do you want this to fire everytime the workbook opens? Do you want to be able to manually incriment the number without closing/opening the file? Can you upload your file so we can work on it or do you want to install this yourself?

1 more replies
Relevance 49.61%
Question: Excel Form Help

Help! I own a small limousine company and would like to develop forms in Excel so that when clients call in I can easily type their information into the contract and have it nice and professional looking. How do I save my worksheet as a form and set cells up so that I can automatically enter text? If this rambling question is too big to answer in this setting, can you recommend a book or two for my reference library? Any help is greatly appreciated! Thanks!Tim

Answer:Excel Form Help

See  For more references, do a Google search on creating forms with excel.  Access, might word equally well or better for this, depending on exactly what your requirements are. 

3 more replies
Relevance 49.2%

I put a similar post on TSG in July 2008, but never received an answer specific to my question.


Using Access 2000
Input form that uses a table (not a query) as the data source
"Order By" property set to sort by name -- last, first, middle, suffix
Some computer-illiterate people tried to add records to the database
Form subsequently displayed records in ID order, not by name
Deleted "Order By" entries and saved form
Reopened form and inserted Order By using last, first, middle, suffix
Form still displays records in ID order
Opened form and switched to Datasheet View
Highlighted LN, FN, MI and SUFX columns and clicked the "AZ" icon to order ascending
Form now displays records in name order
I have run into this problem numerous times and have had to solve it each time by switching to datasheet view and doing an ascending sort. The Order By property does not appear to work, at least not in this version of Office. Seems to me that the Order by property should control the order regardless of what the idiot inputters do to screw things up. Why doesn't it?

Answer:Access form ignoring "Order by"

10 more replies
Relevance 49.2%

Hi all, hopefully an easy one ... I'm using VBA in Excel 2003 & am loading a ComboBox from an Access 2003 database as follows :With KA_Form.KA_ComboBox1 .Clear Do .AddItem KA_RS_Leagues![League_Name] KA_RS_Leagues.MoveNext Loop Until KA_RS_Leagues.EOF End WithIt works fine, if, for instance, I have 3 entries, "A", "C" & "E", they will display in the ComboBox in that order, exactly as I want.If I then Add "B" or "D", or if I delete "C" and re-Add "C", the next time that I look at the ComboBox, they are not in order, it will list "A", "E" and then the newly added "B", "C" or "D" ...Is it possible to make these display in Alphabetical order, EVERY time they are listed, regardless of their order in the Database (The database consists of 2 fields only, an AutoNumber and the Alphabetical entry, League_Name) ?I think that all makes sense .......

Answer:Excel VBA order of data in ComboBox

Here's some code click here that sorts values in a ComboBox.

2 more replies
Relevance 49.2%

I am a newbie in excel & this site. I have dates in a column on a spread sheet. Document already had year in the column & is needed for other functions. I need date order by month-day or day-month (I don't want the year) I highlight the column, click on alignment box, then number tab, then date-get list of date types. Choosing month-day or day-month options still orders by year you can't see. 06/08/32 original date coumn06/03/3306/16/3406/14/3606/25/378-Jun day-month3-Jun16-Jun14-Jun25-Jun or6/8 month-day6/36/166/146/25Any help will be greatly appreciated. chornerBelow not sure about CPU/RAM. Here is more info in case it helps: Intel(R) Core(TIM) i7 CPU [email protected] 2.67 GHz, 64 bit operating sys.

Answer:day-month order not working in excel

Easiest way is to use a "helper" column.With your data in Column AIn column B enter a formula like: =MONTH(A1)&DAY(A1)drag down as many rows as neededNow select BOTH columns A & B, but SORT on column BSee how that works.MIKE

2 more replies
Relevance 49.2%

looking for code to count order numbers but an order number may appear more than once if there are more than one material per order. In the report all orders and all the materials on the order are pulled in for a given time period. therefore if order 623456 has lines 10, 20, 30 then order 623456 appears on the report 3x. I cannot remove duplicates as the data that corresponds to these line items is needed for further info. I want to count the order numbers less the duplicates.


Answer:Excel-count order numbers

10 more replies
Relevance 49.2%
Question: Excel Mileage Form

I have Miles in column C, Cost in Column D at 15.5 pence per mile. I need a Macro to automatically enter Cost, please.

Answer:Excel Mileage Form

Right click the sheet tab, View Code. Copy and paste inPrivate Sub Worksheet_Change(ByVal Target As Range)If Target.Column = 3 Then Application.EnableEvents = False Target.Offset(0, 1).Value = Target.Value * 0.155 Target.Offset(0, 1).NumberFormat = "$#,##0.00" Application.EnableEvents = TrueEnd IfEnd Subthen close the code window.

4 more replies
Relevance 49.2%
Question: Excel - User Form

I know this can be done in Access, but was wondering if it can be done in excel.

What I am looking for is a User form that is always open, and it has an "imput field" where I can enter a series of numbers.

For example, the user form would be up, and when I enter S10131 it would run a macro, without having to hit enter, or anything, I guess so once 6 letters/numbers are entered, it would run a macro.

Any ideas? Sorry I am being kinda vague, but I dont really know what I want yet LOL!

Answer:Excel - User Form

16 more replies
Relevance 49.2%

If I have an expcel worksheet that I want to print multiple copies of each having a consecutive number what is the formula or macro that I need to use to create the numbers.

Answer:numbering a form in excel

In the Related Posts section just below your post found this:

2 more replies
Relevance 49.2%

I've built a form for entering data. I have a list box to help identify codes. You can either choose from the list, or type a code directly into a text box. If you choose from the list, it automatically put's that code into the text box.

I want to limit the selections to ONLY those on the list. If we choose from the list (transferring that code to the text box) it does. However, the user is "able" to type in anything directly to the text box.

I have set up validation on the spreadsheet where the data is ultimately recorded. If you type directly on the spreadsheet, the validation works, and you get an error when the item is not on the list. If you enter the "invalid" code in the text box of the form, it transfers to the spreadsheet without error, even when it is not on the list.

Any ideas how I can:
1) Allow picking from a list and
2) Allow typing the code directly but still requiring a match to ones on the list
3) Transferring the data (keyed or picked) to the field on the spreadsheet.


Answer:Excel Form & List Box

16 more replies
Relevance 49.2%

Hi, I m trying to find a way to clear the fill-in boxes of an excel form after it was used so that it can be used again, is there a way to do that? I currently use MS Excel 2003

Answer:Clear an excel form

Try this link: Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 49.2%
Question: Excel - Input Form

Hi, thanks for reading this.

First off, I should probably mention I have no VBA experience. What I'm trying to do is create an input page for automatically filling out data on another sheet. This data will then be referenced by other cells throughout the book. I've looked up how to do this, but it looks like I'm going to need knowledge of writing macros (I'm working on it). I've attached a sample spreadsheet with the column headers of the data I want the input page to fill. I couldn't think of a way to do this by using vlookups. Is there an easy way to do this without macros?

I'm using excel 2010

Answer:Excel - Input Form

Do you know how to create the form and add all the necessary controls?

2 more replies
Relevance 49.2%
Question: Excel Form Issue

I have a MS Excel spreadsheet with a form attached. How do I get the form to launch on opening of the spreadsheet? In Access, I know you just save a macro as autoexec, is it the same principle?Thank you

Answer:Excel Form Issue

Yes, you name the macro Auto_Open

2 more replies
Relevance 49.2%

I am trying to make a form page on a site to collect info that people enter in and I want to collect it into an excel document. I was told that this is very easy in frontpage but I can't figure it out. I also have dreamweaver if that helps. Please help me.

Answer:form collecting into excel

Try to save results in .CSV file (it's comma separated values), but You need to use some scripting language (ASP, PHP).
I think that in Frontpage You have to make a webbot as action of form (along with FrontPage Extensions) and then in options window create appropriate saving method, but I'm not sure as I do not work with Frontpage

1 more replies
Relevance 49.2%

I have a very large file that records our staff Annual leave and other absences. but all the information has to be entered by me, when people request leave via e-mail or via paper leave forms.
I would like to be able to automate this, the best way would be for a form to be sent via e-mail. If it could some how then update my existing data base this would be great.

Andy body out there who can help


Answer:EXCEL: Add data from a form?

8 more replies
Relevance 49.2%

Here is my predicament.
I have developed a program for my work (Excel).
The first Sheet is the "Invoice Sheet" on this sheet I can enter a stock number and the description field as well as the price field automatically populate with data pulled from another spreadsheet (database).
Sheet 2 The "Fax Order" form automatically populates based on the information on the Invoice sheet.

All information is put in on the Invoice Sheet then if I wish to Order. I only need switch to the Fax order sheet and Fax it off. Here is the problem.... I now wish to be able to E-mail these orders in. I can't attach the file as it contains the database ( and all of our pricing etc. )
I can't break the sheet off as it has links to the other sheet were it gets its data from. I thought of making a 3 Sheet that had links that fill in the "value only" and then attach the sheet, but there again that sheet would have to be its own workbook and I don't think I can "paste special" (Values only) a link to another workbook. Any Ideas on how this might be accomplished?

Thanks in advance

Answer:E-mailing Excel form

7 more replies
Relevance 49.2%
Question: Solved: Excel Form

I'm trying to make a really easy form in excel that will display results based on a field of entry but I'm not good at VBA script.

I was hoping someone could show me how to make a file that takes the information from a datasheet (attached is a sample) and returns values.

I want you to be able to punch in a store number into cell C4 on sheet Form and have it search sheet Data and return the names of the programs (row 1) that have Y in the box. So if I put 5 into the box it would return:

Program 2
Program 3
Program 4

Answer:Solved: Excel Form

14 more replies
Relevance 49.2%
Question: Excel--Form-List

I want to create a list in excel that I can set to an exact size. The list to be 4 wide * 22 deep.size when finished 21cm * 9 cm.Many thanks Terry


Assuming that you mean 21cm deep x 9 cm wide...Adjust column width to 10.71 and row height to 27.75

2 more replies
Relevance 49.2%

I have made tons of forms in word. I then lock them and offer then to groups to complete as part of processes.
I now need to create a form in Excel so that I can set up links to a master file. I found the control Box and forms
tool bars, but to us ehtem and make the form "pretty" I just can't figure out. I also want to lock the form so that
employees can "tab" to the cells that need to be completed. Help from the Excel Assitant does not help me.

If anyone can help, I would appreciate it.

Thank you in advance!

Answer:Creating an Excel Form

16 more replies
Relevance 49.2%

When using the Data-Form facility using criteria to enter address details like organisation, address, contact etc, is it possible to configure so it recognises words and inserts them automatically. e.g. When not using the form you can enter London,Birmingham etc initially and then it picks them up when entering them again and inserts them for you.Hope you get my drift...using excel 2003 if it helps.Advice would be much appreciatedDurko

Answer:Excel and using the Form facility

isnt that "auto complete", or do you want to set a range of keywords that are recognised, maybe the use of a combo box to allow you to choose from a list?just a few ideas, i have no idea how to implement them but im sure someone will.

8 more replies
Relevance 49.2%

Good Morning
I'm trying to build a nice data entry form in Excel. Has 5 required fields, the first 2 of which should default to name and todays date - which is at the top of the spreadsheet. I have 5 buttons: Next, Previous, Add, Delete, Close. I'm working on the code for those. But in the meantime, I'm hung up on the following problem:

Some code that I have written keeps taking Name out of the spreadsheet cell A1. I can understand how that can happen when I run the form's code. But now when the form is closed, and I try to type the name back into A1, it will not stay. When I hit enter, it just disappears, not even in the formula bar. I've checked the formatting and nothing is odd there. If I insert a new row 1, the old row (now 2) works, and the new row 1 still has disappearing text. So something in my code is telling it to blank out cell A1. I don't understand how that can happen if I don't even run the code?

The following is all the code behind the form. The only other code in the project is a button click on sheet one. The only code directly referring to Cell A1, is at the very bottom with the A1 reference bolded. Thanks for your help.

Dim CurrentRow As Long

Private Sub cmdAdd_Click()
' Save form contents before changing rows:
' If list is empty start in row 5:
If Cells(5, 1).Value = "" Then
CurrentRow = 1
' Set current row to first empty r... Read more

Answer:Excel Code for a form

I have tried recreating the problem that you describe but with no success.
What version of Excel are you using?
Can you post the file? It would save others having to recreate the form.

I think I found a bug in your code.

In cmdAdd_Click and UserForm_Activate I think that the following line:
CurrentRow = 1
needs to be changed to
CurrentRow = 5
given your comments in the code.

Is there any other information that you can give?

3 more replies
Relevance 49.2%
Question: excel sheet form

Hi there, all wizards.

Sitting here at work trying to build, for me way to comprehensive automated excel travel expense report form.

I dont know much about vba, so i'm lost, and i dont know wether i can get the controls to find what i would like in one table in different sheet. For if i choose one "country", i want a control to show this country in one base cell, then to collect corresponding amount in next set of colums, so that i can get the form to calculate as much as possible with less input from user.
That was problem nr 1

2 problem is
i like to use form control textbox to place data in different cells, telling 1: start date, 2: end date. third cell i want to calculate how many days it has been in between.
This i also want for calculating hours.

REason for this is to use these values as base to wether calculate in the findings with corresponding values in other sheet. When done with all my final layouts, and formulas i lock the form sheet, and leave only some cells open in sheet with reference tables.
Cant upload file here, limit says 200kb (way low)

Answer:excel sheet form

6 more replies
Relevance 49.2%

Hi all,

A client wants data in Excel on 254 questions. This exceeds the capacity of the built-in form function and even is causing some problems in Access, due to the odd way they want the data in Excel (transposed from how a database will store it - I am sure I can work around that if necessary, but...) Is there an add-in for Excel that will make forms that can handle so many columns?


Answer:Excel 97 form problem

7 more replies
Relevance 49.2%

I have an excel spreadsheet with some questions on it. I can create a form with the questions on it using "Data - Form". What I would like to do is email this form to about 12 people (instead of the whole Excel spreadsheet) and ask them to complete and return to me. Is there any way that this can be done?Thanks in advance.

Answer:how to email an excel form

I don't use Excel but normally, in the case of MS programs and applications, from (generally) File you can usually Send To i.e. in this case a mail recipient or recipients.

6 more replies
Relevance 49.2%

I have these two files: template(attached for reference), The Data file.

The Template – is a form I want to populate with data from the (data file) i attached it so you can see(i want macro to open the datafile filter it by distributor and list all the data for each particular distributor then copy the data and open the template file and paste the copy data on cell a6:g6 and down depend on how many data it pull for that particular datafile.

The datafile – that file has all the information/data I want to populate on the template

PS: I want to be able to run a macro where, macro would filter my data file by distributors and copy the data distributors by distributors and paste it in to the template file(after each distributor/filterdown it create a new ws for the new set of data for the next distributor). I attached some example but I didn’t send the data file OR i would like to have a macro to run every time the value change in cell "c2" it opens the data file and if c2 match value a2 in data file, i want it to copy all the data for that value in column a then copy and come paste it to template form. i attached the template and example or reference.

Your help is greatly appreciated!! plz

Answer:Populate excel form

6 more replies
Relevance 49.2%

I have a Excel 2003 spreadsheet which contains lot's of columns. This spreadsheet view by many people but only I edit it. I created a userform which neatly displays all the columns, in a Excel form view, and allows the viewer to move up/down the spreadsheet's fields. My problem is trying to get either a button or selectable box which would let the viewer select from one the 3 different worksheets in the workbook, all while staying in the userform. I don't want the viewers to ever see the spreadsheet. The 3 worksheets all have the exact same layout. I've seen some macro examples that I inserted in the VB code has a module, but they all pull up a dialog box in the spreadsheet view, and I want the viewers to view the data within the userform I created. Any ideas/code example would be greatly appreciated.


Answer:Excel Form Question

9 more replies
Relevance 49.2%
Question: Excel Form Fields

Is there a way to set forms up in Excel like Word? When I have the form toolbar open, the Text Form Field icon is grayed out. Thanks for the help!

Answer:Excel Form Fields

There's no Text Form Field icon on Excel's Forms toolbar, it's an EditBox button. It's greyed out because it can't be used on a worksheet, only on a UserForm (custom dialog box).

There are ways you can get Excel to jump to various cells for user input, it depends on exactly what you want to do.

Click on A3, hold down CTRL, click on A5, A7, A9, A1. Release CTRL. Select Format -- Cells -- Protection, uncheck "Locked", click OK. Protect the worksheet (Tools menu), then you can tab around the sheet in that order (starting with A1).


1 more replies
Relevance 48.38%

Hi,I could really use some expert assistance on a problem I'm having trying to find a macro to do what I need to do and if anyone could assist, it would be greatly appreciated.I'm posting this particular problem on this forum, because I've seen a lot of similar solutions to the problem I have posted here already, but not close enough where I can copy the code and make it work for myself. I have two columns of Part Numbers from two similar indented Bills of Material. These list can be as long as 18K rows. From the top down, I need to go down each of the list and put the matching entries from column A on the same row as the matching entry in column B or vise-versa, (leaving spaces adjacent to non-matches). The kicker here is that the sort order of either column can not change, because that would interfere with the identity of the product structure. Therefore, there will be blank cells next to those Part Numbers that appear only on one Bill of Material. So the only thing that will happen is that things will shift down in each column until there are matching aligning cells in a row. Seems odd, but the whole idea here is that someone can take two BOM?s for similar products and have a side-by-side comparison. The matches will be easy to spot because they will be directly beside each other. In a nut shell if you were to go back and remove the blank cells from both columns, you would be right back where you started, because the order of each list will still be the same. Ag... Read more

Answer:Excel 2007 Compare Two Col, Keep Sort Order

Sorry, having problems understanding what you need.Post a small example of your data ( 10 or 15 lines, with headings and row numbers) if you can give a before and after, but first read this on how to do it:

6 more replies