View Single Post
  #5   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

do you mean that you don't want the user to be able to add there own
values to the list?? if so you can set the combobox to act as a drop
down list that restricts the user to having to choose one of the
contained values. you can change this in the Style property from the
properties panel, just change the setting to fmStyleDropDownList.

Steve