ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help With Restricting Values in Data Entry Forms please (https://www.excelbanter.com/excel-programming/299625-help-restricting-values-data-entry-forms-please.html)

Carnage

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


Roger Whitehead[_4_]

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/





All times are GMT +1. The time now is 04:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com