Named range

Hi Guys

I am attempting to put together a userform with comboboxes.

I wish to use named ranges within the comboboxes, which form the list.

I normall use something similiar to below to enable me to form the list within the dropdown box, but removing underscores, neccessary within ranges.

[/HTML]=INDIRECT(SUBSTITUTE(F1,? ?,?_?)),[HTML].

Question, can somone please show me how to put a "active x combobox" together using a list from a range without underscores.

Many thanks in advance.

Keith

Hi Keith,

Probably easier to help if you could attach a sample file with your list and your userform. There is more than likely a better way than using the named range but would need to see the file to best advise.

BSB