I am adding a listbox to my excel program I am working on. When I go to populate the RowSource the property is not there. Am I missing something?
I am adding a listbox to my excel program I am working on. When I go to populate the RowSource the property is not there. Am I missing something?
Is it an ACtiveX listbox? If so, look for ListFillRange.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks for the answer checked and ListFillRange is there.
The RowSource property is not supported on Mac. The work-around I use is
[VBA]UserForm1.ListBox1.List = Application.Transpose(Range("A1:A10").Value)[/VBA]