data validation and forms

G

Gary Keramidas

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.
 
C

Chip Pearson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

best way to validate data in forms; 2010 1
Date Entry through input prompt 9
Combo Box Data Validation - First Entry Blank 2
get Data Validation to stop, list supplied, duplicate data entries 1
If formula and Data Validation parallely 1
execute assigned data validation in vba? 11
Data Validation blanks for formulas 18
A data validation question 1

Top