View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Zych[_7_] Tim Zych[_7_] is offline
external usenet poster
 
Posts: 21
Default Is There A "Choose Cell " Event?

There is the Selection_Change event of the worksheet. The BeforeDoubleClick
event is a nice(er) alternative.

Private Sub Worksheet_BeforeDoubleClick(ByVal _
Target As Range, Cancel As Boolean)
If Not Application.Intersect( _
Target, Range("A10")) Is Nothing Then
Cancel = True
MsgBox "double-clicked " & Target.Address
End If
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect( _
Target, Range("A10")) Is Nothing Then
MsgBox "selected " & Target.Address
End If
End Sub


"Minitman" wrote in message
...
Greetings,

Is there any way to trigger an event by simply moving the cursor to a
particular cell? If so, how many ways are there to trigger an event
in this fashion?

For example, The cell in question can be A10. The event to be
triggered is to open UserForm1. I

It is easy using Command Buttons, but I am looking for alternatives.

Any one have any ideas?

TIA

-Minitman