Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling a macro upon selecting a cell
when i select a cell, say B2, a message box comes up with a message i wrote
in a macro at some point in the past. it asks if i want to proceed w/ the subroutine. for the life of me, i cannot figure out how to get to this code. it does not appear to be in vbe, at least not under modules (there are non in this spreadsheet). how do you call a sub by simply selecting a cell and where is the code stored? thanks, mike allen -- mikeallen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling a macro upon selecting a cell
Right click on the sheet tab of the sheet the cell is in. Then click View
Code. It sounds like a worksheet_change macro. "mikeallen77" wrote: when i select a cell, say B2, a message box comes up with a message i wrote in a macro at some point in the past. it asks if i want to proceed w/ the subroutine. for the life of me, i cannot figure out how to get to this code. it does not appear to be in vbe, at least not under modules (there are non in this spreadsheet). how do you call a sub by simply selecting a cell and where is the code stored? thanks, mike allen -- mikeallen |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling a macro upon selecting a cell
perfect! i would have never found it, even though i have obviously used it
before. thank you. -- mikeallen "JLGWhiz" wrote: Right click on the sheet tab of the sheet the cell is in. Then click View Code. It sounds like a worksheet_change macro. "mikeallen77" wrote: when i select a cell, say B2, a message box comes up with a message i wrote in a macro at some point in the past. it asks if i want to proceed w/ the subroutine. for the life of me, i cannot figure out how to get to this code. it does not appear to be in vbe, at least not under modules (there are non in this spreadsheet). how do you call a sub by simply selecting a cell and where is the code stored? thanks, mike allen -- mikeallen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Pause for selecting cell | Excel Discussion (Misc queries) | |||
Help for Macro: Finding last cell and selecting it | Excel Discussion (Misc queries) | |||
Macro - Selecting Next Available Cell | Excel Programming | |||
Calling macro on cell change | Excel Programming | |||
Macro selecting the last used cell does not work | Excel Programming |