I am trying to use an array for the rowsource value in the listbox for a userform. I think my array code is correct, but the listbox.rowsource doesn't like the array name as the value. I am populating my array with the sheet names and trying to fill the list box with that array. Here is my code:
How do I reference the array in rowsource in the properties explorer?
Please Login or Register to view this content.
Thanks,
John W
Rowsource may only be address of a range. You may use List property with arrays.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Thanks for your quick reply.
Would the syntax be:
Please Login or Register to view this content.
Yes - this must be before line to show form
Surprised you didn't' just try it. It should work.
If you are happy with my response please click the * in the lower left of my post.
Thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks