Help On User Form

M

mastee

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
 
D

dominicb

Good morning Mastee

You really need to supply more information about what you are doing an
what you want to achieve. You will need to set up a button (eg "OK") s
that Excel knows when you've completed a box and use some code behin
that button. However it depends whether you want to put the result
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 control
into cell A1 of your active sheet. Without any further information
can't guide you any further.

HTH

Dominic
 
M

mastee

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

Maste
 
Top