Thread: Combo Box initial values question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default Combo Box initial values question
Hi Teepee,

Try something like:

Me.ComboBox1.ListIndex = 0


---
Regards,
Norman


"teepee" wrote in message
...
Does anyone know how to make a combo box show a value when a sheet opens?
Mine are always blank when I open them until I select a value.

thanks

tp




Reply With QuoteReply With Quote