Posted to microsoft.public.excel.programming

Snake Plissken[_2_] Snake Plissken[_2_] is offline

external usenet poster

Posts: 75

Is this possible? Click a cell to run a macro

| Private Sub Worksheet_SelectionChange(ByVal Target As Range)
|
| If Target.Address() = "$A$1" Then
|
| Call "myMacro"
|
| End If
|
|
| End Sub
|
|
1. the code above should be put in sheet area in VBA editor

2. of course "myMacro" is the name of a macro so write it without quotation
marks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Click in cell to run macro	alistew	Excel Discussion (Misc queries)	7	February 20th 07 05:03 PM
Macro on cell click??	Jim Thomlinson[_5_]	Excel Programming	0	February 6th 06 09:33 PM
Macro on cell click??	Gary''s Student	Excel Programming	0	February 6th 06 09:29 PM
Run Macro on Cell Click..	CliffHanger9	Excel Programming	0	November 17th 04 07:46 PM
Run Macro on Cell Click..	scottymelloty[_12_]	Excel Programming	1	November 17th 04 06:15 PM

All times are GMT +1. The time now is 01:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us