Hoopsah
06-25-2008, 12:28 AM
Hi,
I have a spreadsheet where there is a macro button that once clicked submits all the information to a spreadsheet/database.
What I am looking for is something to add into the code that will pop up an error message box if the conditions are not met.
The conditions are: If A1 is complete then B1 cannot be, if B1 is complete then A1 cannot be, If neither A1 or B1 is completed then show error too.
The second one I need help with is a working days scenario on a completely different spreadsheet, so I am going to post it on a completely different thread.
Cheers
Hoopsah
I have a spreadsheet where there is a macro button that once clicked submits all the information to a spreadsheet/database.
What I am looking for is something to add into the code that will pop up an error message box if the conditions are not met.
The conditions are: If A1 is complete then B1 cannot be, if B1 is complete then A1 cannot be, If neither A1 or B1 is completed then show error too.
The second one I need help with is a working days scenario on a completely different spreadsheet, so I am going to post it on a completely different thread.
Cheers
Hoopsah