activate VBA
 

It is possible. Let's say your macro celltoast is in a standard module. Say
we want the macro called whenever cell Z100 is clicked.

In the worksheet code area enter:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("Z100")) Is Nothing Then
Exit Sub
End If
Application.EnableEvents = False
Call celltoast
Application.EnableEvents = True
End Sub


REMEMBER: the worksheet code area, not a standard module
--
Gary''s Student - gsnu200737


"geebee" wrote:


hi,

i would like to know how i can activate a VBA sub celltoast() when i click a
cell in MS excel. is this possible? if so, how?

thanks in advance,
geebee