Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation and forms
what's the preferred way to use data validation with an input form? if data is
entered directly into a cell, validation works, if i use an input form, it allows any entry. -- Gary |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation and forms
any ideas on this?
-- Gary "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... what's the preferred way to use data validation with an input form? if data is entered directly into a cell, validation works, if i use an input form, it allows any entry. -- Gary |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation and forms
Data Validation only applies to input made by the user, with the
keyboard and mouse. It doesn't apply to changes made by VBA code. You'd have to write your own validation routine in the form itself. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... what's the preferred way to use data validation with an input form? if data is entered directly into a cell, validation works, if i use an input form, it allows any entry. -- Gary |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation and forms
ok thanks chip, will do. just wanted to make sure
-- Gary "Chip Pearson" wrote in message ... Data Validation only applies to input made by the user, with the keyboard and mouse. It doesn't apply to changes made by VBA code. You'd have to write your own validation routine in the form itself. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... what's the preferred way to use data validation with an input form? if data is entered directly into a cell, validation works, if i use an input form, it allows any entry. -- Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation/Forms Combo Box | Excel Discussion (Misc queries) | |||
Data Validation and Forms | Excel Discussion (Misc queries) | |||
Forms Toolbar vs. Control Toolbox vs. Data Validation for drop dow | Excel Discussion (Misc queries) |