Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help With Restricting Values in Data Entry Forms please
Good Morning All,
I have created a data input form by following the "Course Booking Form tutorial on the website. And i have a couple of combo boxes. Is i possible to use some form of data validation to restrict entries int the cell i.e. so you can only write into the combo boxes exactly wha is in the combo list? (possibly with customised dialogue boxes)? Any help would be appreciated. Thanks, Aaro -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help With Restricting Values in Data Entry Forms please
Check out the MatchRequired property of the ComboBox Control
-- HTH Roger Shaftesbury (UK) "Carnage " wrote in message ... Good Morning All, I have created a data input form by following the "Course Booking Form" tutorial on the website. And i have a couple of combo boxes. Is it possible to use some form of data validation to restrict entries into the cell i.e. so you can only write into the combo boxes exactly what is in the combo list? (possibly with customised dialogue boxes)? Any help would be appreciated. Thanks, Aaron --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Entry with forms | Excel Worksheet Functions | |||
Restricting data entry to unique entries only in a specific range | Excel Discussion (Misc queries) | |||
Restricting data entry to A-Z a-z 0-9 | Excel Discussion (Misc queries) | |||
Data Validation - but not restricting values | Excel Discussion (Misc queries) | |||
Restricting entry in B1 on the basis of entry in A1 | Excel Worksheet Functions |