Thread: combobox
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sunilpatel sunilpatel is offline
external usenet poster
 
Posts: 57
Default combobox

i have the following code.

ActiveSheet.ComboBox2.Clear
ActiveSheet.ComboBox2.AddItem "Enter Quantity"
ActiveSheet.ComboBox2.ListIndex = 0
ComboBox2.Visible = True

I would like the "Enter Quantity" to be highlighted, so a number can be
entered without using the mouse.

Thanks