View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fernando Ronci Fernando Ronci is offline
external usenet poster
 
Posts: 14
Default Dynamically assign items to a list box

Thank you Chip,
I'm getting closer.
I was able to run this simple test macro:
Private Sub ListBox1_Click()

For rw = 1 To 5
With Worksheets("Hoja1")
Me.ListBox1.AddItem.Cells(rw, 1).Value
End With
Next

End Sub

However, when I run the macro (F5) the listbox is empty, I mean, the test
data at A1..E1 aren't shown within the listbox.
What am I missing ?
Thank you,
Fernando

"Chip Pearson" wrote in message
...
Fernando,

With the UserForm open in VBA, select the listbox in question,
press F4 to display the Properties window, and look at the Name
property.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com