I have this marco that i need some help with.

[baldi]

how do I get this marco to stop if there is no value in cell E3. Then let the user know that they must first enter a value in cell E3 before the marco will continue.

[FONT=Calibri][SIZE=3][COLOR=#000000]answer = MsgBox(prompt:="Does CASH IN or CHIPS equalCHIPS OUT", Buttons:=vbYesNo + vbCritical, Title:="Update DaysValues")[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]    If answer = vbYesThen[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]   Sheets("Sheet2").Select[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]   ActiveSheet.Unprotect "alexandeR"[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]   Sheets("Sheet3").Select[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]   ActiveSheet.Unprotect "alexander"[/COLOR][/SIZE][/FONT]

thank you in advance.

 

[Roderick_E]

if trim(range("E3"))="" then
exit sub
endif

perhaps?

 

[rlv01]

To build on Roderick_E's answer if you want to display a message to the user

    If Trim(Range("E3")) = "" Then
        Range("E3").Select
        MsgBox "Cell E3 is empty!" & vbCr & vbCr & "Please enter a value in cell E3", Buttons:=vbOKOnly + vbExclamation, Title:="Cell E3 needs a value"
        Exit Sub
    End If

 

[baldi]

that worked great thanks for the help

 

[baldi]

how do I and a formula to it. like if the sum of cells B15 and E15 do not EQUAL cell H15 the marco stops.

 

[Roderick_E]

how do I and a formula to it. like if the sum of cells B15 and E15 do not EQUAL cell H15 the marco stops.

if range("B15")+range("E15")<>range("H15") then
exit sub
endif

 

[baldi]

if range("B15")+range("E15")<>range("H15") then
exit sub
endif

that worked out great.
thanks for the help