Ignoring blank values in a combo box

[hallingh]

I have a userform combo box that is getting its values from a named range. However, the named range has blank cells separating values, which obviously looks pretty ugly when the combo box is clicked. Is there any way to get the userform combo box to ignore any blank cells it encounters?

Thanks for the looks.

Hank