Help On User Form
 

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


--
mastee
------------------------------------------------------------------------
mastee's Profile: http://www.excelforum.com/member.php...o&userid=23826
View this thread: http://www.excelforum.com/showthread...hreadid=398070

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


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=398070

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


--
mastee
------------------------------------------------------------------------
mastee's Profile: http://www.excelforum.com/member.php...o&userid=23826
View this thread: http://www.excelforum.com/showthread...hreadid=398070

i am attaching my order form screenshot can somone help i want to sort
this out urgent :confused:


+-------------------------------------------------------------------+
|Filename: Screenshot.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3721 |
+-------------------------------------------------------------------+

--
mastee
------------------------------------------------------------------------
mastee's Profile: http://www.excelforum.com/member.php...o&userid=23826
View this thread: http://www.excelforum.com/showthread...hreadid=398070

Please Any One Help Me


--
mastee
------------------------------------------------------------------------
mastee's Profile: http://www.excelforum.com/member.php...o&userid=23826
View this thread: http://www.excelforum.com/showthread...hreadid=398070