Run a subroutine from a worksheet without button, menu, or shortcut key…

  • Thread starter Thread starter qpg
  • Start date Start date
Q

qpg

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
 
Subs can be triggered from worksheet events, e.g. Worksheet_Change()
and
Worksheet_SelectionChange().

Hth,
Merjet
 
Subs can be triggered from worksheet events, e.g. Worksheet_Change()
and
Worksheet_SelectionChange().

Hth,
Merjet
Click to expand...

Thanks but I think it needs to be a little more intentional than that.
Anyone have anyother ideas?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling a subroutine - how to? 4
Calling Subroutines from sub-routine 4
Call a subroutine from ThisWorkBook 3
Call subroutine problem 1
Calling a VBA add in from a macro subroutine 1
Run two macros for two different sheets 11
Calling a subroutine with a command button 2
Run Access Subroutine (or Function) from Excel 2

Back
Top