Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run a subroutine from a worksheet without button, menu, or shortcut key…
Im looking for a way to run a sub from a worksheet. Something
equivalent to a command line in AutoCAD. I had in mind entering a function in a cell that would return True when done but in the mean time call a sub routine and allow for range selection, etc. It does not seem that this can be done with a function calling a sub but does anyone have a workaround? Is there a way to trigger a sub from cell or the formula bar? Thanks, Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run a subroutine from a worksheet without button, menu, or shortcut key…
Subs can be triggered from worksheet events, e.g. Worksheet_Change()
and Worksheet_SelectionChange(). Hth, Merjet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run a subroutine from a worksheet without button, menu, or shortcut key…
On Jun 12, 10:04*am, merjet wrote:
Subs can be triggered from worksheet events, e.g. Worksheet_Change() and Worksheet_SelectionChange(). Hth, Merjet Thanks but I think it needs to be a little more intentional than that. Anyone have anyother ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Shortcut Menu | Excel Discussion (Misc queries) | |||
Shortcut menu won't appear when I click right mouse button. | Excel Discussion (Misc queries) | |||
Excel desktop shortcut to cmd button in worksheet | Excel Programming | |||
VBA to disable "Delete...." on shortcut menu of worksheet tab? | Excel Discussion (Misc queries) | |||
Shortcut menu on worksheet tab | Excel Programming |