Run Macro on Mouse Click
It's in all Excel since Excel 97.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"vacation" wrote in message
...
I am working in Excel version 2000. Is Worksheet Selection Change event in
there?
"Richard Buttrey" wrote:
On Thu, 13 Jul 2006 10:58:02 -0700, vacation
wrote:
Is is possible to run a macro that displays a pre-set number upon
clicking in
a cell?
For example: everytime someone needs to see the value 24 in cell b4 all
they
have to do is click in that cell to make that number visible.
Thank you
The following in the Worksheet Selection Change event should do the
trick
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("B4")) Is Nothing Then Range("B4")
="24"
End Sub
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
|