Hi William,

That's spot on - cheers!

Stan

"William" wrote:

Hi Stan

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

--
XL2002
Regards

William



"Stan" wrote in message
...
| 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
|