Thanks, Tom, for the help. What I did is seen below, for pasting Quicken Data
into a specific cell. First, a command button which when clicked gives
instructons to select B2. Then a Selection change to force selection of B2.
My problem is I don't know how to shut off the selection change handler once
B2 has been selected and the Quicken data pasted there. I continues to prompt
selection of B2 ever after!!
Any suggestions?
JCIrish
Private Sub btnStartQuicken_Click()
Dim readyCheck
MsgBox("Are you ready to enter Quicken Values?", vbYesNoCancel)
If readyCheck = vbYes Then
MsgBox "Select Cell B2"
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = Range("B2").Address Then
MsgBox "Paste Quicken Values"
Else
MsgBox "You must select Cell B2"
End If
End Sub