Help On User Form

**mastee** · 08-23-2005, 04:05 AM

Hi All,

Can any one help me in this .I have made a orderform with some combobox and tickboxes a simple form i want to collect the data at the end of the sheet .Like when i select certain item from drop down box is there away that data can be collected at the end of the sheet.I
Many Thanks in Advance

Mastee

**dominicb** · 08-23-2005, 05:04 AM

Good morning Mastee

You really need to supply more information about what you are doing and what you want to achieve. You will need to set up a button (eg "OK") so that Excel knows when you've completed a box and use some code behind that button. However it depends whether you want to put the results into a spreadsheet cell or load it into memory.

Range("A1").Value = TextBox1.Value
Range("A1").Value = ComboBox1.Value
Range("A1").Value = OptionButton11.Value
Range("A1").Value = CheckBox1.Value

Each of the lines above will put the result of one of your controls into cell A1 of your active sheet. Without any further information I can't guide you any further.

HTH

DominicB

**mastee** · 08-23-2005, 05:17 AM

Thank you DominicB .Basically i have created a sandwich order form for my catering unit on excel.If you can send me your email i will forward you the email sandwich order sheet .I have divided the sheet in three options by inserting dropdown buttons .When a customer select a bread ,Margarine ,Selection of Any meat and accompinments i want to see the selection at the column provided which will be helpful for my staff to prepare the sandwich by looking at the data .I will send you the created form which you gives you the much broder picture want i am saying about. Any how thanks alot.

Mastee