UserformListbox Header

[sthiru]

Hi

I'm trying to put header for Listbox in userform. I have tried rowsource but it is not working the value just populating in another row instead of header - Please sort me out guys.

Please Login or Register  to view this content.

Thanks
Thiru

[newdoverman]

I just saw this this morning and you might be able to solve your problem if you watch this video. You have to pay close attention as the property dialogue is opened and various changes are made.

http://www.youtube.com/watch?v=5oXcct1mOUw

[sthiru]

Hi

Anyway I found it below are the steps to use it - This is for the guys who struggling in Userform Listbox Header .

To list header first we should change the Listbox property Column Heads to true
Then in vba use shoud use rowsource i.e. listbox1.rowsource = "A10:D5" - The value in the A11 to D11 will be the header. And also This will take acivesheet range so just specify the range only, don't specifiy the sheet name or workbook name.

And if you are clearing the listbox you should use Listbox.rowsource = "" - You should not use Listbox.clear it will throw error.

Please Login or Register  to view this content.

Thats it guys.

Thanks
Thiru