Preventing Writing in Combo Boxes

S

Stan

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
 
W

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

[email protected]

| 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
|
 
Top