Validation button using VBA

[rmeffert]

Hello everyone! You guys helped me out of a huge jam a few weeks ago
and I was hoping you could help me out on this less critical add-on
would like to do for my companies spreadsheets.
We have lets say 3 columns - (city, state, zip). I would like to creat
a button that called <Validate> that a user can click to ensure tha
the data entered matches the validations in the cells. And if i
doesnt, I want the macro to highlight the cell that does not conform t
the validation in red. I have seen this done before, I was hopin
someone could assist.


Ex: Validation set in state column is 2 chars - however someone type
out the whole state, when this button is pushed it will highlight tha
state in red so the user knows its in error.


Thank you so much ahead of time

 

[Bob Phillips]

What are the rules on City and zip? Is there a list of values for state?

Either way, Data Validation ism probably what you want.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)