Check if cell was empty Excel VBA

Question

I am writing an Excel Macro to display a warning if the user edits a cell that was previously empty. Basically if a cell is edited, is in column 1, and already contains text I want to display a warning But if it does not have text already, I do not want to.

So what I have tried is the following

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 1 And Not IsEmpty(Cells(Target.Row,Target.Column)) Then
        Application.EnableEvents = False
        MsgBox "Some Message"
        Application.EnableEvents = True
    End If
End Sub

The issue I am having is when I am getting the cell to see if it was empty or not, it will never return that it was because, well the user just added stuff to it.

So I want to know if there is a simple way to check the previous state of that cell. I want to find out if the cell WAS empty. Is this possible?

@mr.Reband Thanks for that, I tried searching for a question on here but I guess I was not using the proper search terms. — MZimmerman6
– MZimmerman6, Commented Sep 12, 2013 at 14:49

Declan_K · Accepted Answer · 2013-09-12 14:18:18Z

4

You could use the Worksheet_SelectionChange event to capture the value of the cell that the user has selected in a variable, which happens before they make any changes.

Then when Worksheet_Change is fired, you can refer to that variable.

answered Sep 12, 2013 at 14:18

Declan_K

6,8162 gold badges22 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MZimmerman6 Over a year ago

This is exactly what I ended up doing, and was based off of the comment that mr.Reband posted as a comment.

Collectives™ on Stack Overflow

Check if cell was empty Excel VBA

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related