Try this
Private Sub Worksheet_SelectionChange _
(ByVal Target As Range)
If Target.Address = Range("A1").Address Then
MsgBox "Help"
End If
End Sub

"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??