Pop up message when data is entered

[jlbrowneyes]

Hello. I am new to the site but have already found a TON of helpful information! I would like some assistance with a 2007 Excel spreadsheet. My company currently shares ONE spreadsheet to generate new project numbers (Shown below). My issue is once a new number is assigned, it is supposed to be entered into our accounting software but that doesn’t appear to be happening in some cases.
Is there a way that a pop up message can appear when column G is populated (Entered by)? Something like, “please be sure to enter this XYZ”.

Thank you in advance for any advice or assistance you are able to offer!

 

[VBA Geek]

You could create a worksheet event. In your VBA Editor, select the desired sheet then on the top you choose "worksheet" from the drop down menu and on the right drop down you need to choose "change" then you can enter

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 7 Then
MsgBox "Please be sure to enter " & Target.Value
End If
End Sub

 

[jlbrowneyes]

Ok now I feel bad because I can not see where to select "worksheet"

https://www.dropbox.com/s/4zpyuq4e6gx1mhl/VBA.jpg

 

[VBA Geek]

First you need to double click one of the sheets, the one where your data is then you will see the above image

 

[jlbrowneyes]

And I considered myself SOMEWHAT tech savvy!! Well did as shown, hit save and then went back into the spreadsheet but no pop up appeared when I entered data into column G

https://www.dropbox.com/s/4zpyuq4e6gx1mhl/VBA.jpg
spreadsheet image: https://www.dropbox.com/sc/rebsilxhk3niqrj/70hLHBqgZV

 

[VBA Geek]

You need to type if target.Column = 7, not target.Column = G

 

[jlbrowneyes]

dag on, you are good!!!!
Now the pop up window appears except after the last word "Vision" somehow it's showing up as "Visionfsds". Do you know why?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 7 Then
MsgBox "Please be sure to enter as opportunity in Vision" & Target.Value
End If

End Sub

 

[VBA Geek]

Target.Value represents what you are typing into the cell, so I guess you are typing Visionfsds?

 

[jlbrowneyes]

The pop up only appears when the column is populated from my computer. Can it appear regardless of who enters the data from wherever? Remember, this spreadsheet is shared among all employees.

 

[VBA Geek]

if they are opening the same workbook then it should work for whoever uses it