Creating a link to a subroutine...

[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

 

[Harald Staff]

Hi

Use a textbox from the drawing toolbar. Format it transparent fill, no
border and with underlined blue text. Finally assign a macro to it by
rightclicking its edge.

 

[Pablo Chemes]

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