Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Userform in excel
I want to build a userform containing at least 5 combo boxes besides
other controls.The userform should load data from sheet1 and what ever the user has selected should be saved in sheet2.The Value of combo2 should populate after selecting combo1 and combo3 should populate after Combo2 is done and so on. Also is it possible to show multiple values the user selects from select lists in a text box/text area and he should be able to select /deselect the values from this text box/ area. Any quick response with examples will be a great help to me. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Userform in excel
You are not going to get a quick response, and it is quite long-winded, and
what have you done to date? First combobox is simple, just set the list link to the range on sheet 1. Dependent comboboxes are quite straightforward, but need code to make the decision as to what is populated in there, as with the others. I would suggest a Listbox to store the selected values, that can also be selected from. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ST" wrote in message oups.com... I want to build a userform containing at least 5 combo boxes besides other controls.The userform should load data from sheet1 and what ever the user has selected should be saved in sheet2.The Value of combo2 should populate after selecting combo1 and combo3 should populate after Combo2 is done and so on. Also is it possible to show multiple values the user selects from select lists in a text box/text area and he should be able to select /deselect the values from this text box/ area. Any quick response with examples will be a great help to me. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Userform in excel
This example in VBAExpress might help get you started
http://vbaexpress.com/forum/attachme...p;d=1152742444 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Bob Phillips" wrote in message ... You are not going to get a quick response, and it is quite long-winded, and what have you done to date? First combobox is simple, just set the list link to the range on sheet 1. Dependent comboboxes are quite straightforward, but need code to make the decision as to what is populated in there, as with the others. I would suggest a Listbox to store the selected values, that can also be selected from. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ST" wrote in message oups.com... I want to build a userform containing at least 5 combo boxes besides other controls.The userform should load data from sheet1 and what ever the user has selected should be saved in sheet2.The Value of combo2 should populate after selecting combo1 and combo3 should populate after Combo2 is done and so on. Also is it possible to show multiple values the user selects from select lists in a text box/text area and he should be able to select /deselect the values from this text box/ area. Any quick response with examples will be a great help to me. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |