Hi
I've developed a macro to select and copy data from one workbook to another. When the data is successfully copied the macro displays "Copied to Database" in cell T5.
I'd like to set the macro up to first check that the check cell is empty before proceeding, otherwise stop the macro and display an error prompt box.
I have the following working, however I have no idea how to start to display an error prompt box...
I've developed a macro to select and copy data from one workbook to another. When the data is successfully copied the macro displays "Copied to Database" in cell T5.
I'd like to set the macro up to first check that the check cell is empty before proceeding, otherwise stop the macro and display an error prompt box.
I have the following working, however I have no idea how to start to display an error prompt box...
Code:
'Check if rows have been copied already
Range("T5").Select
If Selection = "COPIED TO DATABASE" Then Exit Sub