How to prevent focus by clicking combo box ?

[dennis logan]

Hi.

I want to prevent focus when the user clicking combo box so that the user
can't change the list. I have tried to look in excel help, but find nothing.


Thanks
dennis logan

 

[Incidental]

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

 

[dennis logan]

If I disable the combo box. the user can't click it to select the list. What
I need is the combo box still active while the user can't change the list. By
the default. it is possible to select and change the list.

 

[Zone]

Try changing the Match Required property to true. James

 

[Incidental]

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

 

[dennis logan]

I have tried to set the Match Required property to true but the focus still
exist, i.e. I can type any character in combo box. Is it possible to block
this focus ??

 

[dennis logan]

It works!! Thanks so much Steve.

 

[Zone]

Steve's solution was better. James

I have tried to set the Match Required property to true but the focus still
exist, i.e. I can type any character in combo box. Is it possible to block
this focus ??