Userform - Populate Combo Box with Column Number and 1st row data

[KevBotes]

Hello all,

I need to populate a combo box on a form with the column name (A,B,C...etc) and the first row data. I need the code to check all columns in-case of missing column data.

Its important to note the data will be dynamic. In my add in, a form opens on requests and asks the user which column he needs to action data on. this could be on any one of several non similar spreadsheets.

EG: Combox to hold the following data (see column D has no data or header row):

Column A - Date
Column B - Rep
Column C - Customer
Column D -
Column E - Product

How can i pass this info to the form ?

[playaller]

Are there a set number of columns A through E or random?

[playaller]

This will capture the first empty cell of data on the first row

Please Login or Register  to view this content.

You can now use cletter in your continued coding for the column letter.

[KevBotes]

Thanks for the reply, i have not yet tested it though.

And, the number of columns will be random.