Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
i am attaching my order form screenshot can somone help i want to sort this out urgent +-------------------------------------------------------------------+ |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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form in VB = TextBox | Excel Discussion (Misc queries) | |||
Print scrollable user form. | Excel Discussion (Misc queries) | |||
user form | Excel Discussion (Misc queries) | |||
Data Entry Alert in User Form | Excel Discussion (Misc queries) | |||
A "previous" button on a user form | Excel Discussion (Misc queries) |