View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Incidental Incidental is offline
external usenet poster
 
Posts: 226
Default How to prevent focus by clicking combo box ?

Hi Dennis

Not very clear what you are asking but you can set the enabled value
of the combobox to false this will allow the user to see the value
that is held in there but they are unable to change it also you will
be able to get the value out any time you need using code.

combobox1.enabled=false

hope this is of some use to you

S