Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox List to Open when uderform is Activated ?
Can a Combobox list be Dropped Open displaying the list of values when a
userform is Activated. I want to Fool-Proof Prompt the user to select this value 1st. Can this be done? How? Sub userform_Activate() combobox92.dropdownlist=activate ' ??? end sub Corey.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox List to Open when uderform is Activated ?
Never mind.
Solved it just as i posted. ComboBox92.DropDown Funny thing is though: The Values are NOT displayed IN the Combobox, they are Displayed In the Centre of the Userform. NO problems for me though, just means the User would have to TRIP OVER the values to miss them. Corey.... "Corey" wrote in message ... Can a Combobox list be Dropped Open displaying the list of values when a userform is Activated. I want to Fool-Proof Prompt the user to select this value 1st. Can this be done? How? Sub userform_Activate() combobox92.dropdownlist=activate ' ??? end sub Corey.... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox List to Open when uderform is Activated ?
Corey,
Using .DropDown in the Userform_Initailize event, I get strange behaviour; the list portion appears outside of the form. In the _activate event, it works fine. NickHK "Corey" wrote in message ... Never mind. Solved it just as i posted. ComboBox92.DropDown Funny thing is though: The Values are NOT displayed IN the Combobox, they are Displayed In the Centre of the Userform. NO problems for me though, just means the User would have to TRIP OVER the values to miss them. Corey.... "Corey" wrote in message ... Can a Combobox list be Dropped Open displaying the list of values when a userform is Activated. I want to Fool-Proof Prompt the user to select this value 1st. Can this be done? How? Sub userform_Activate() combobox92.dropdownlist=activate ' ??? end sub Corey.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Test if WorkSheet ComboBox list is open | Excel Programming | |||
userform open when sheet activated | Excel Programming | |||
List box activated on opening file | Excel Discussion (Misc queries) | |||
List Open Workbooks in a combobox | Excel Programming | |||
message/dialog box auto open when excel file is activated | Excel Discussion (Misc queries) |