| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping a Macro If a cell is left blank
Good morning,
I need to have an email macro stop and show a userform if a cell in a worksheets is left blank. How in the world can I do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Stopping a Macro If a cell is left blank
Something like this...
If Trim(Sheets("sheet 1").Range("A1").Value) = "" then UserForm1.Show else 'proceed as normal end if -- HTH... Jim Thomlinson "David A." wrote: Good morning, I need to have an email macro stop and show a userform if a cell in a worksheets is left blank. How in the world can I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell to return a specific value if left blank | Excel Worksheet Functions | |||
| Find & Delete columns to the left stopping at column B | Excel Programming | |||
| Find & Delete columns to the left stopping at column B | Excel Programming | |||
| Stopping the "Next" command when a blank cell is reached. | Excel Programming | |||
| counting from left to right and stopping when blank | Excel Discussion (Misc queries) | |||
Linear Mode
