Comments - display on dirty

[Belinda7237]

I have a column in a spreadsheet that requires the user to input info.

Once the user inputs info into that cell, i want to create a pop up box
reminder to that when this cell is completed they will need to perform a task.

How do i write somethin gto accomplish this?

this is a shared workbook and many users will need to enter in this column
on occassion

 

[JLGWhiz]

In one place you say you have a column and in another you infer a single
cell. In either case, I believe you would need to use the Worksheet_Change
event to initiate the message box. The psuedo code below should give you an
idea.

Private Sub Worksheet_Change(ByVal Target As Range)
Set MyRange = Sheets("SomeSheet").Range("SomeRange")
If Intersect(Target, MyRange) Then
MsgBox("Do Something")
End If
End Sub

 

[Belinda7237]

thanks, i almost get it:

Here is what i used based on your suggestion:

Private Sub Worksheet_Change(ByVal Target As Range)
Set MyRange = Sheets("Central Master Repository").Range("Y:Y")
If Intersect(Y:Y, Y:Y) Then
MsgBox ("Please add comments regarding the letter in the comments
box")
End If
End Sub

I think the intersect is wrong - basically the coumn is Y and it could be
any cell within that Y column. What change should i make?