if ""

  1. pedie

    Please modify my current code! If any of the cell from A3 to F3 is "" then exit sub

    If any of the cell from A3 to F3 is "" then exit sub, how do we set this up?:) Thanks Pedie Current Sub CommandButton2_Click() If Range("b3") = "" Then MsgBox "You must assign a Detail Number in cell B3" Range("b3").Select Exit Sub Else Run "Report" End If End Sub

Some videos you may like

This Week's Hot Topics

Top