Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assign a formula to count items in a column if they are within cor | Excel Worksheet Functions | |||
dynamically sorted list with duplicates | Excel Worksheet Functions | |||
Dynamically changing the size of a list | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Assign macros to dynamically created form elements | Excel Programming |