Never mind all. I have answered my own question. Thanks to all those who
helped me learn. I just scratched the service on learning how to write code
and I am very excited!!
Here's what I came up with to solve this solution. (Hope it helps those who
may need similar solutions.)

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Intersect(Target, Range("A2:G2")).Address Then MsgBox "Ok"
End
End Sub

Thanks again to all those who posted replies and those who posted on this
website! It has helped me greatly get a small handle on basic coding!

Steve

"Steve" wrote:

I have a spreadsheet with a column that contains a formula. I want to create
a pop-up box that when someone trys to type in the cell it pops up with a
warning of sorts. I do know how to make it so that if some clicks in the
cell it creates a pop-up, but I only want the pop-up to appear when they make
the cell active by double clicking in the cell or typing in the cell.

Is this possible??