View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sandy Sandy is offline
external usenet poster
 
Posts: 355
Default validation all cells different format

Hello -

I have a number of cells with different formats, e.g. E5 is a text cell that
has to be filled in; E6 is a numeric cell that has to be filled in and E7 is
a date cell with the format mm/dd/yyyy.

I would like to put a button in that will validate all the cells. How do I
go about doing this? Is it possible?

Any help will be immensely appreciated!
--
Sandy