Getting Combo Box to show -Please select- text

[galpinm]

I am adding a ComboBox to a worksheet, purely in a list format with several available choices. However the default view is none of these choices show immediately - the box is blank until you hit the drop down arrow. Does anyone know how I can enter the text --Please Select Data Type--- to show in the box at the beginning ?
thx
Mark

[Andy Collyer]

Combo1.Text = "-- Please Select Data Type --"

HTH

AndyC