Validating Excel

  • Thread starter Thread starter Joshua
  • Start date Start date
J

Joshua

I am trying to update a datatbase from excel. How do I
validate the data entered in a paricular cell (NOT COLUMN)
Could someone help me out
 
I am trying to update a datatbase from excel. How do I
validate the data entered in a paricular cell (NOT COLUMN)
Could someone help me out
Click to expand...

You can do some rudimentary data validation through the Data menu,
Validation... option. Just like any normal format, you can copy the
validation settings through copying and pasting. More than that I
couldn't say considering that I don't know what type of validation you
want to do. Also, there's no way to prevent the validation from being
overridden by simply pasting values from other cells into the
validated ones. Excel doesn't really provide strong validation
options, unless you do a fair amount of behind the scenes VBA work to
achieve them.
 
Back
Top