pedie
Well-known Member
- Joined
- Apr 28, 2010
- Messages
- 3,875
If any of the cell from A3 to F3 is "" then exit sub, how do we set this up?
Thanks
Pedie
Current
Thanks
Pedie
Current
Code:
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