Thread
:
Preventing Writing in Combo Boxes
View Single Post
#
2
Posted to microsoft.public.excel.programming
William[_2_]
external usenet poster
Posts: 227
Preventing Writing in Combo Boxes
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
|
Reply With Quote
William[_2_]
View Public Profile
Find all posts by William[_2_]