Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
validate all cells before save
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
validate all cells before save
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validate multiple cells in to one dropdown box | Excel Discussion (Misc queries) | |||
validate cells | Excel Programming | |||
HOW DO I GET EXCEL TO VALIDATE TWO CELLS AT ONCE | Excel Discussion (Misc queries) | |||
Validate cells have data | Excel Worksheet Functions | |||
Validate Cells based on if conditions | Excel Programming |