I found this information that gets me started:
Use the selection change event.
'======
Right click on the sheet tab and select view code.

In the left dropdown at the top of the module select Worksheet
in the right dropdown at the top of the module select SelectionChange

this will place the declaration in the module.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

you can put your code he

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
if Target.Address = "$A$1" then
Userform1.Show
End if
End Sub
'====== Thanks Tom Ogilvy
(From URL:
http://www.microsoft.com/office/comm...af4&sloc=en-us )

What I would like to know is how can this be dynamic? Example: If a user
deletes a row, how or can the above event still function?
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007