Thread
:
validate all cells before save
View Single Post
#
3
Posted to microsoft.public.excel.programming
Spencer
external usenet poster
Posts: 29
validate all cells before save
ok...i see that i could loop through all my cells that contain data
validation, but how do i check the validity of the cells?
"Don Guillett" wrote:
You could do either. Have a look in the vba help index for FINDNEXT
--
Don Guillett
SalesAid Software
"Spencer" wrote in message
...
i have an application that used data validation to ensure that entries into
cells are valid...duh. however, i use macros to change the values of
these
cells and the validation does not get picked up. is there a way to either
have this validation work when a macro changes a cell value or, maybe even
better, run a macro before the user saves the workbook that will validate
all
of the cells. are eitehr of these possible? TIA.
Reply With Quote
Spencer
View Public Profile
Find all posts by Spencer