how to make a link to a function or subroutine...

  • Thread starter Thread starter Pablo Chemes
  • Start date Start date
P

Pablo Chemes

Hi, I have an spreadsheet with some VBA code with functions and
routines...

I'd like to call those subroutines or functions clicking a cell, or
some text of the cell. (like a hiperlink).

I don't want to use buttons, or the click event of cells...

I guess I could write a kind of function like =HYPERLINK ... that I
could call like this:

=MakeLink(sub-to-run,text-to-display-in-cell)

I'll appreciate your ideas..
regards,

JPC
 
Your idea doesn't meet the criteria you state:
I'd like to call those subroutines or functions clicking a cell, or
some text of the cell. (like a hiperlink).
Click to expand...

the only macro activity generated by clicking a cell is the activity in the
click event or by an actual hyperlink.
 
Thanks.

I've tried what you said and worked fine...
but then I found another workarround:

I've set the desired Cell to be a hyperlink... to the same sheet and cell
and in the followhyperlink event I've wrote the call to the code I needed.

Thanks again.
JPC
 
Back
Top