I have a userform that is actually 8 separate forms (I did this instead of using darn multipage that doesn't let me change the color of the multipage tabs). Page one starts a new row in a table on "SkinData" worksheet. Pages 2-8 just keep adding more data to that same row. All 8 forms must be completed or our audit is incomplete.
It's fine to use the 'x' on page 1....because a new row hasn't been started yet. But, my problem is if they close using the "x" in the corner of the form on pages 2-8, it could mess our data up.
So, if they use the 'x', I want it to give them a yes/no "Are you sure" kind of warning. Then, if they say yes to close (and they're on any page other than page 1), I want the row they started to be deleted. This will ensure we don't have fragments of data.
One more thing....I already have the row # started by page 1 in a 'validations' worksheet (cell DA2). So...either I can tell it to delete that row OR I guess I could tell it to delete the last row in column A (only columns A-G are completed by page 1 so it would have to look at one of those...there are like 60 columns but I guess that doesn't matter if I delete the entire row).
So...HELP and a pre-thank you for those who help!
HTML Code:
Bookmarks