User-Form Problem: User can select headers in User Form (I want Header/no way to select)

Greetings everybody

So I have the following code as part of a userform I modified slightly from a Book (Excel 2010: Power Programming with VBA). I cant seem to see the attached image but what I get is the headers with a selection box next to it, what I want is for the first row to not be selectable. I need the headers but I don't want the user to be able to select them. I already programmed around this, since the macro ignores this selection but it looks unfinished with this issue. Will appreciate any and all support.

I know this could probably be explained better but I can't find an easy way to explain

Please Login or Register  to view this content.

Have you set ColumnHeaders to true for the listbox?

What range are you using to populate the listbox and which row are the headers in?

Hi Norie

Sorry for my ignorance, very new with userforms, I don't know how to check your first question. Would that be to simply add something like ".Columnheaders = true"?

Headers are in row 1

The range's rows are dynamic, the columns are A through H. The way its programmed it takes everything on the sheet:

Please Login or Register  to view this content.

Thanks for the help

You could set ColumnHeaders at design or run time.

As for the range, does it actually include row 1?