VBA Code warning message ANY empty blank cell Entire worksheet

Hi All,

I am extremly new to using VBA and Macros. I do not understand the code, but want to learn. I will attempt to explain what I would like VBA code for and what I would like it to accomplish.

I have a Data Worksheet that is the Data portion of my Pivot Table.

I want the user to be warned with a popup message when they tab without filling in data in that and any other cell in the worksheet. I have googled for probably 8 hours and cannot find this exactly and am not smart enough to figure out the code to modify what I have found at this point.

Please help.

My worksheet is named Data and my Pivot Table (if you need that) is named Pivot

Thanks in advance for any and all help!

Where you need this message in worksheet or pivotable?

See this link http://www.ozgrid.com/forum/showthread.php?t=13995

I read through this thread you provided and am probably doing it wrong.

I press Alt F11 or right click on "Data" (name of my worksheet) copy and paste the following code:

Sub Example()
Dim cell As Range

For Each cell In Range("Data")
If IsEmpty(cell) Then
MsgBox ("Empty Cells exist") 'actions To Do If True
End If
Next
End Sub

It does not work when I go to my worksheet

The Excel Forum server was having problems when I posted this. Can someone please analyze my code and see what I am doing wrong. Please read from start.

I tried something like this as well, but it didn't work either.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
If IsEmpty(PrevCell) Then
MsgBox ("Please fill in all cells") 'actions To Do If True
End If
Next
End Sub

Try

Please Login or Register  to view this content.

It pops up with the message whether the previous cell was empty or not, so this is not working. I am not sure the "change" code is the correct way to go about this. Thanks for trying. Any other suggestions?

Post a example of what you looking to do

Ok, here is my worksheet. Data, Data Links (for Data validation list drop downs), and Pivot Table.

Please see attached file and read previous thread.

Please help!