Non-Editable ComboBox?

N

NooK

I am quite new to VBA and I am writing a program which have a couple of
ComboBoxes and those comboBoxes are not to be editable.

I have looked everywhere on the net and couldn't find it.

How can I make them not editable so the user can only choose the
choices in the box and not be able to write anything in it?

I tried setting Locked property to True but then I can't select
anything (When I click on the arrow down it doesn't do anything).

Hope someone can help me.

Best Regards

NooK
 
H

Harald Staff

Hi NooK

Set the Style property to "List" instead of "Combo".

HTH.Best wishes Harald
 
H

Hank Scorpio

I am quite new to VBA and I am writing a program which have a couple of
ComboBoxes and those comboBoxes are not to be editable.

I have looked everywhere on the net and couldn't find it.

How can I make them not editable so the user can only choose the
choices in the box and not be able to write anything in it?

I tried setting Locked property to True but then I can't select
anything (When I click on the arrow down it doesn't do anything).
Click to expand...

It's not the Locked property, but rather the MatchRequired property
that you need to set to True.
 
Top