Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have three cells (A3, B3 & C3) where I'm using data validation to control
the contents. My worksheet also has a macro button to generate a set of reports when clicked. I want to update that macro by adding a check for those three cells to ensure each has been completed, and cancel processing if they have not. Can someone provide guidance on setting up the IF statement? If A3:C3 is blank (not sure how to code this part here) MsgBox stating cell X or cells XXX are blank and required Exit Sub Else ' Do nothing, Ok to continue w/rest of macro End If Also, is it better to call a separate macro from my existing macro or just add the check to the one I already have? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy a worksheet and ensure range names stay local | Excel Programming | |||
Ensure Named Range is in ThisWorkbook | Excel Programming | |||
how do I ensure that the sum of two cells does not exceed a set fi | Excel Worksheet Functions | |||
Is it possible to ensure Calendar date is in range | Excel Programming | |||
How to ensure function does not refer to cells outside of workbook? | Excel Programming |