VBA to stop macro and display error message

[kylesom]

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...

'Check if rows have been copied already
    Range("T5").Select
    If Selection = "COPIED TO DATABASE" Then Exit Sub

 

[jbeaucaire]

'Check if rows have been copied already
    If Range("T5") = "COPIED TO DATABASE" Then 
        MsgBox "This sheet already processed, aborting..."
        Exit Sub
    End If

 

[kylesom]

Thanks!

 

[jhogan21]

I have used this code to make sure that a textbox requiring a date is filled out, however, when i then add the date to the text box and try to continue with my macro, the command button that allows this does not do anything. i would like once someone puts the date in, for the macro to continue, any help would be appreciated. here is my code i am using.

Sheets(2).Activate
emptyRow = WorksheetFunction.CountA(Range("D:D")) + 1
Cells(emptyRow, 1).Value = LabelRoute10
Cells(emptyRow, 2).Value = ListBoxAccountName.Value
Cells(emptyRow, 3).Value = DateTextbox.Value

If DateTextbox.Value = vbNullString Then MsgBox "Please input date for this survey", vbCritical
Exit Sub

Unload Me
Brands.Show