Prev: XL 2007: How to find out what keyboard shortcuts I've assigned to macros?
Next: Help with VBA and SUM
From: Philosophaie on 18 May 2010 16:56
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
..

From: JLGWhiz on 18 May 2010 17:25
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" <Philosophaie(a)discussions.microsoft.com> wrote in message
news:A442E23E-D51D-4C38-BA46-EF9E75A0807F(a)microsoft.com...
> 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
> .
>


 | 
Pages: 1
Prev: XL 2007: How to find out what keyboard shortcuts I've assigned to macros?
Next: Help with VBA and SUM