Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro upon clicking a cell?
I wrote a little macro (module, general) and at the moment it's runnin on pressing ctr+q. Now I wonder if it's possible to make it run everytime i click a cell. Or if not so, then if it's possible to make it run like every seconds. Please note that this is my first excel macro, so i don't really kno anything about macroes yet, thx in advance, the blue ride -- theblueride ----------------------------------------------------------------------- thebluerider's Profile: http://www.excelforum.com/member.php...fo&userid=3775 View this thread: http://www.excelforum.com/showthread.php?threadid=57339 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro upon clicking a cell?
On selecting a cell
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Const WS_RANGE As String = "A1:H10" If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target 'do your stuff End With End If End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "thebluerider" wrote in message news:thebluerider.2csi5g_1155995408.9223@excelforu m-nospam.com... I wrote a little macro (module, general) and at the moment it's running on pressing ctr+q. Now I wonder if it's possible to make it run everytime i click a cell. Or if not so, then if it's possible to make it run like every 2 seconds. Please note that this is my first excel macro, so i don't really know anything about macroes yet, thx in advance, the blue rider -- thebluerider ------------------------------------------------------------------------ thebluerider's Profile: http://www.excelforum.com/member.php...o&userid=37754 View this thread: http://www.excelforum.com/showthread...hreadid=573391 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro upon clicking a cell?
Paste this in to the worksheet code module. Every time you click a cell on the worksheet it will call your macro Private Sub Worksheet_SelectionChange(ByVal Target As Range) Call YOUR MACRO NAME HERE End Sub Regards, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=573391 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro upon clicking a cell?
This could work, right click on the worksheets tab select view codes in the code window select worksheet from the drop down, in the dropdow to the right select SelectionChange place you macro code in the sub, when ever you change the selection o the sheet the macro will kick in. Use the code below as an example: MsgBox "Macro goes here" Private Sub Worksheet_SelectionChange(ByVal Target As Range) MsgBox "Macro goes here" End Su -- davesexce ----------------------------------------------------------------------- davesexcel's Profile: http://www.excelforum.com/member.php...fo&userid=3170 View this thread: http://www.excelforum.com/showthread.php?threadid=57339 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Run a Macro from clicking a cell | Excel Worksheet Functions | |||
Run a macro when clicking a cell. | Excel Worksheet Functions | |||
Run a macro after clicking into cell | Excel Worksheet Functions | |||
Launching a macro by double-clicking on active cell | Excel Programming | |||
Run macro from clicking on a cell | Excel Discussion (Misc queries) |