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

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
|

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
|