LinkBack URL
About LinkBacks
How would I write a messagebox popup if cell H11 is empty in my workbook.
Thanks Z
How would I write a messagebox popup if cell H11 is empty in my workbook.
Thanks Z
Last edited by zplugger; 07-10-2011 at 08:11 AM.
That depends on when you want the message box to appear.
When the user tries to save the workbook? After changing the value in H11? After clicking a button?
On a basic level you could use Data Validation, but that would only be good if the user tried to enter a value into H11 (or remove a value from the cell). As part of a macro (save, button, etc.) it would be something like:
If Range("H11").Value = "" Then MsgBox "You must enter a value in cell H11!"
Thank You, this will work
I was wrong, still not working right. My workbook has 4 different sheets,if it open on sheet 3 the message will not work until I change sheets. I tried workbookchange but with a command button to clear the form it pop up the message. Not sure how to make it work when it open to the starting sheet. Here is the code I use.
Private Sub Worksheet_Activate() If Range("H11").Text = "" Then MsgBox "You need to Insert Invoice Number Rick " Cancel = True Exit Sub End If End Sub
So back to my original question, when do you want it to pop up?
When the workbook opens, or whenever Sheet3 becomes the active sheet?
Thanks Paul, I set my workbook to open on a sheet that does not use the warning. Thanks again for getting me on the right path.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks