Amend code to check cell A2 has data in before running

Hi,
Can anyone please advise me of the change I need to make to the syntax of the following code
to also check that there is data in cell ‘A2’ on the ‘Requests In Delivery (Data)’ tab


If InputBox("Enter Password To Update Formulas") <> "go" Then

MsgBox "Sorry Wrong password/No data in cell A2"
Exit Sub

End If

So when the macro is run it will prompt the user for the password ‘go’ and also check to see if there is data in ‘A2’ on the ‘Requests In Delivery (Data)’ tab before continuing with the rest of the macro code


Many thanks in advance for any assistance in this matter


Regards


Rob

kasan,

Excellent !! Many thanks for all you help it works as required

Regards


Rov