Populate Combobox using column headers

Hey Guys,

I want to populate a combobox using the column headers (from row 1) on sheet1, i want the range to be dynamic, i've tried simply using a dynamic range which expands across rather than down with no luck.

I think i need to transpose a dynamic range or something similar. Can i do this from entirely within vba, so i dont have to define a range within excel (less to go wrong?)

Thanks in advance,

Jack

Just a normal combobox, from the toolbox, on a userform.

Sorry i didnt get all of it for some reason!

Thats works perfectly roy thankyou, is there a method of removing the spaces? And is there a way of organsing the list alphabetically?

Thankyou so much!
Jack

Hi Roy,

The list is continuous, however at the end of the list the white space goes on for a very long time...

How would i go about sorting a horizontal range, without moving the positions of the columns? The idea of transposing keeps coming into my mind?

Many thanks,
Jack

Hi Roy,

I just made you an majorly thinned down example workbhook, and it works fine with no spaces!? Typical! going to go over the orignal and see if i can see the problem..

Yep, i reopened once and it didnt work again, closed it and reopened and now it work every time.. ??
Oh well, at least its solved!

The alphabeticall ordering is impossible i take it?

Thankyou for all your help,

Jack

You are actually a genius, no idea how you did it, but it works perfectly, thankyou very much!!

Thankyou again, its extremely generous of you to donate your time to people like me! You're a great bloke!

Regards,
Jack

Cheers Roy, thats works great, I couldnt of asked for more!

Thanks again, your help was much appreciated.

Jack