Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Do excel cells have "activate" events? 1

Status
Not open for further replies.

AncientTiger

Programmer
Jul 5, 2001
238
US
Forgive an old LotusScripter for this question, but is there a way in Excel to
have a script activated when the user moves focus into a particular cell?
 
Cut & paste this. It'll give you the general idea...

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If ActiveCell.Address = "$A$1" Then
MsgBox "You're at the first cell in the spreadsheet"
Else
End If
End Sub
Tyrone Lumley
augerinn@gte.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top