Preventing Writing in Combo Boxes

[Guest]

Hi All,

I have a series of combo boxes and want to ensure people only select what is given in the boxes. I have set the matchtype to 'complete' and 'true' however am still able to write in what I like which in turn puts the wrong value elsewhere.

Is there any means of preventing people writing in what they like? Or am I missing something with what I've done?

Any help would be greatly appreciated.
Thanks,

Stan

 

[William]

Hi Stan

Within VB, select the combobox and then go to the combobox properties.
Change the style from "fmStyleDropDownCombo" to "fmStyleDropDownList"

--
XL2002
Regards

William

(e-mail address removed)

| Hi All,
|
| I have a series of combo boxes and want to ensure people only select what
is given in the boxes. I have set the matchtype to 'complete' and 'true'
however am still able to write in what I like which in turn puts the wrong
value elsewhere.
|
| Is there any means of preventing people writing in what they like? Or am I
missing something with what I've done?
|
| Any help would be greatly appreciated.
| Thanks,
|
| Stan
|

 

[Guest]

Hi William,

That's spot on - cheers!

Stan