Run macro based on cell conditions

[MarcDenney]

Hi All,

i have 2 tabs of data and a macro that uses data from both of them.

Basically i need some code to check that the data has been entered.

For Example:

select sheet 1, check that cell B2 contains "Batch number", if it doesn't display error message, if it does then move on to:

select sheet 2, check that cell B1 contains "Account no", if it doesn't display error message, if it does then move on to running main macro.

Any help would be greatly appreciated.

Thanks

Marc

 

[VoG]

Try like this

If Sheets("Sheet1").Range("B2").Value <> "Batch number" Then
    MsgBox "your message here"
    Exit Sub
End If
If Sheets("Sheet2").Range("B1").Value <> "Account no" Then
    MsgBox "your message here"
    Exit Sub
End If
'
'rest of code

 

[MarcDenney]

Worked like a charm.

Thanks