mutliple "beforesave" functions in same workbook

**billkelley** · 10-20-2008, 12:37 PM

..again, thanks to this forum...great people....

I have my VB code working great - spreadsheet now requires data entry in a specific cell and that requirement has been delayed until a certain date with a IF THEN statement. Thanks to all that helped!!

I am now trying to broaden the "beforesave" requirement to multiple cells in the same workbook/worksheet. In the below VB statement, I don't know where to insert this additional command to require that a second cell have data entered into it before saving. The cell on the "Request for PTM" worksheet is H12.

I would need a second message to appear relating to that specific cell as well; similiar to first message "Current Installed Irr. System Entry Required"

Please Login or Register  to view this content.

Thanks for all the great help!! You guys are awesome!!!

**SimonK** · 10-20-2008, 03:20 PM

Hi billkelley

If you are going to do the same thing twice in vba, it is worth trying to write a separate function for it that can be used both times. Here is my attempt:

Please Login or Register  to view this content.

As the function StillEmpty returns true or false, you can assign it straight to the Cancel variable.

**MatrixMan** · 10-20-2008, 03:21 PM

Here's code for doing them individually (simple extension of your code, but means that each condition is check in sequence so code exits when it is met and the second condition - if appliable - would only be met on the second attempt to save):

Please Login or Register  to view this content.

And here's code for both at the same time:

Please Login or Register  to view this content.

There is a lot of literature out there about validating data entry and while this sort of check is a good idea you need to be careful about over-using it because it means a user physically can't save the workbook in draft without meeting all your conditions (and if there are lots, then this can be annoying). Hope that helps. MM.