vba msgbox when a cell changes in column

[gd1sum8nfg2]

Hello,
I am fairly new to VBA. What I am trying to do is have a message box for when a cell is changed in an entire column. So say, for instance, I input "10" in cell (A1), a vbokonly message box pops saying "cell changed". and then if (A2) is changed later on, that message box pops up again. So I am trying to write a code for an entire column, but only effects a single cell at a time. Sorry if I am bad at clarifying. Any help is appreciated, Thank you.

 

[Rick Rothstein]

Hello,
I am fairly new to VBA. What I am trying to do is have a message box for when a cell is changed in an entire column. So say, for instance, I input "10" in cell (A1), a vbokonly message box pops saying "cell changed". and then if (A2) is changed later on, that message box pops up again. So I am trying to write a code for an entire column, but only effects a single cell at a time. Sorry if I am bad at clarifying. Any help is appreciated, Thank you.

Personally, that sounds like it would be annoying to the user (wouldn't the user already know he/she changed the cell... why would he/she need a message box to tell him/her it just occurred?). Anyway, given you want to do it, what should happen if the user copy/paste multiple values into several cells in the range being monitor... one message box covering all the changes or a message box for each change?

 

[VoG]

Right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
    MsgBox Target.Address(False, False) & " Changed", vbInformation
End If
End Sub

 

[gd1sum8nfg2]

I understand it is an annoyance. It's for a database, at work. Some of the people using the database don't record some information. This code is going to be for when someone replaces a certain source, a pop up box appears saying something along the lines of "record lot code", that way some people don't forget to do so. In the spreadsheet, there's a column named "Date changed" so if the source wasn't changed, then nothing appears in the cell. If it is changed, the date goes into the cell. So when someone changes a source and inputs the date, that's when I want the message box to pop up saying "record lot code"

 

[gd1sum8nfg2]

Thank you! Worked perfectly.