Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validate Combobox entry
Hi,
Please could someone advise if it is possible to prevent a user from entering free text into a combobox?. If so, are there any examples available, I have searched around the 'net but it is not clear. Mickey |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validate Combobox entry
"MBlake" wrote in message
... Hi, Please could someone advise if it is possible to prevent a user from entering free text into a combobox?. If so, are there any examples available, I have searched around the 'net but it is not clear. Hi Mickey, If you're talking about a Controls toolbar ComboBox (the same kind you put on UserForms) then just change its Style property to "2 - fmStyleDropDownList" in the Properties window. This style only allows the user to select items already in the list. If you type into a ComboBox control with this style it attempts to find a matching item in the existing list by default. You can modify this behavior using the MatchEntry property of the ComboBox. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validate Combobox entry
Hi Rob,
Excellent, many thanks for your kind help. I am as you can see a newcomer to Excel Userforms. I have been considering Professional Excel Development which I believe you worked on, if so can you say if the book is just for experts or will it be of some support to me? Cheers, Mickey |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validate Combobox entry
"MBlake" wrote in message
... Hi Rob, Excellent, many thanks for your kind help. I am as you can see a newcomer to Excel Userforms. I have been considering Professional Excel Development which I believe you worked on, if so can you say if the book is just for experts or will it be of some support to me? Hi Mickey, I'd wait until you have a good grounding in Excel VBA before diving into Professional Excel Development. A better starting place would be our previous book The Excel 2002 VBA Programmer's Reference. Don't worry about the Excel version number in the title, virtually everything covered in that book works in all current versions of Excel. Also, skip the 2003 version of the book, which has our names on it but which we did not contribute to (long story). -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validate Combobox entry
Thanks Rob,
One Programmers Reference purchased. Mickey |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validate Combobox entry
Hi Rob,
What a great book choice that was, the book is excellent and a great help. Thanks for the suggestion. Mickey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validate entry based on another cell value | Excel Discussion (Misc queries) | |||
Validate date entry in a text box. | Excel Discussion (Misc queries) | |||
Validate Email address entry | Excel Discussion (Misc queries) | |||
Validate Textbox entry | Excel Programming | |||
how to validate a combobox? | Excel Programming |