Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting dropdown menu to default value
I am using a series of dropdown menus in a userform.
Is there a way to set the value of a dropdown menu to a default. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting dropdown menu to default value
How about setting the value when you initialise it to one of the options.
The code below uses the userform_initialize event which adds 10 items (testx) to the combobox and then shows the form with Test6 selected Private Sub UserForm_Initialize() Dim x As Integer For x = 1 To 10 ComboBox1.AddItem ("Test" & x) Next x ComboBox1.Value = "Test6" End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk wrote in message oups.com... I am using a series of dropdown menus in a userform. Is there a way to set the value of a dropdown menu to a default. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Setting default value in vba created FormTool Dropdown | Excel Programming | |||
Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) |