Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm1.ComboBox1 to initialize
In "View Code" of Userform1 I can not get UserForm1.ComboBox1 to initialize:
item1 item2 when I show the userform. Private Sub CommandButton1_Click() With UserForm1.ComboBox1 .AddItem "item1" .AddItem "item2" End With .. Userform program .. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm1.ComboBox1 to initialize
The initialize event occurs with the UserForm, not the ComboBox.
Private Sub UserForm_Initialize() With Me.ComboBox1 .AddItem "item1" .AddItem "item2" End With End Sub The ComboBox should then display the two items as options in the drop down. "Philosophaie" wrote in message ... In "View Code" of Userform1 I can not get UserForm1.ComboBox1 to initialize: item1 item2 when I show the userform. Private Sub CommandButton1_Click() With UserForm1.ComboBox1 .AddItem "item1" .AddItem "item2" End With . Userform program . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate dataform with combobox1.value | Excel Programming | |||
What's the difference between 'Set UserForm1=Nothing' and 'Unload UserForm1' ? | Excel Programming | |||
ComboBox1 | Excel Discussion (Misc queries) | |||
Endless Loop when using ComboBox1.BoundColumn = 2 | Excel Programming | |||
3 textbox values based on value in ComboBox1 | Excel Programming |