I've spent some time with the Search feature but couldn't find my answe
so here goes... I have a combobox that reads a list of names. When th
userform opens and the user sees this combobox, I would like to displa
text (such as "Select Name") in the combobox prior to the user clickin
the down arrow. Upon selecting a name, the name would appear in th
combobox instead of the original text. I realize a label woul
accomplish the same thing, but I would like to have it integral to th
combobox. I thought I figured it out when I turned ColumnHeads t
true, but that only displays the header row in the list upon clickin
on the down arrow. I was hoping this would be a property of th
combobox but so far I couldn't find it reading through all of th
options in the help file. Is this even possible to do? Thanks i
advance

--
Message posted from http://www.ExcelForum.com