listbox with column headers as a specific sheet column headers

**ANDREAAS** · 06-07-2014, 03:35 AM

Hi

i have a userform with two listboxes in them, i have set the columns in the listbox to 9 and would like to populate the column headers in the listboxes with the column header of one of the sheets

Please Login or Register  to view this content.

on of my other sheets have the same column headers, but i'd like for the listbox to take the data from a specific sheet so that when i change any of the column headers in that sheet, it will change in the listbox as well next time the userform is opened.

i have tried :

Please Login or Register  to view this content.

,but this gives an error, and this is where the scope of my know how ends too

Any help with this will be greatly appreciated.

**Fotis1991** · 06-07-2014, 03:51 AM

Ηι

How do you get the data=contents in the listbox?
are these from the same sheet that you need to add the headers?

**ANDREAAS** · 06-07-2014, 03:55 AM

client search - Copy.xlsmHi

i have not got that far yet, i posted a thread for that, but keapt adding the wrong sheet for some dilly reason.....

see attached

**ANDREAAS** · 06-07-2014, 03:59 AM

see below link to previous post

HTML Code:

**Fotis1991** · 06-07-2014, 04:27 AM

i am not a vba expert so as an option i used a named range for your range which i used in rowsource of your list box.Not sure if this is what you need.