userform question

[Pjam]

any one tell me why this did not work for filling in my list box

Private Sub ListBox1_Click()
ListBox1.RowSource = "a1:a10"
End Sub

but why this did

Private Sub UserForm_Initialize()
ListBox1.RowSource = "a1:a10"
End Sub

 

[Joe MAyo]

well before the userform shows up on the screen it needs to upload the information that goes in the list box, therefore it should call the rowsource macro before showing the userform

 

[Joe MAyo]

you can also do it like this

Private Sub ListBox1_Click()
With UserForm1
ListBox1.RowSource = "a1:a10"
.Show
End With
End Sub

 

[dougshell]

OK, Please somone help, I'm getting very frustrated!!

I don't know what is going on, I've tried to use the code just as it is shown above but everytime I try to run this and other combinations of the listbox.rowsource code it errors and says "object required".

Any thoughts or ideas.

Here is the code exactly as I'm trying it.

Private Sub ListBox2_Click()
Worksheets("working").Activate
With UserFormICC
ListBox2.RowSource = "a1:a10"
.Show
End With
End Sub