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? |
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? |
All times are GMT +1. The time now is 11:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com