I have a worksheet called Names - and have added a userform to my workbook. I want to set the control source (or the display text whatever it's called) to be my worksheet called Names all of row A except the top row the header. How do I do this?
I have a worksheet called Names - and have added a userform to my workbook. I want to set the control source (or the display text whatever it's called) to be my worksheet called Names all of row A except the top row the header. How do I do this?
If you mean all of column A bar the header row then you can use this to populate the listbox.
Or, alternatively, if you want to use RowSource this.Please Login or Register to view this content.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Using your 1st solution - I get a permission denied error when the form goes to load. The offending line is thelinePlease Login or Register to view this content.
Are you already using RowSource for the ListBox?
No - my project has this VBA
andPlease Login or Register to view this content.
Please Login or Register to view this content.
Any chance you could upload a sample workbook?
Click on GO ADVANCED, scroll down and click Manage Attachments.
I found it. Someone had added the record source in the properties of the form and not in the VBA. I was only scanning the VBA originally.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks