| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to make a link to a function or subroutine...
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to make a link to a function or subroutine...
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). the only macro activity generated by clicking a cell is the activity in the click event or by an actual hyperlink. -- Regards, Tom Ogilvy "Pablo Chemes" wrote in message om... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to make a link to a function or subroutine...
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 "Tom Ogilvy" wrote in message ... 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). the only macro activity generated by clicking a cell is the activity in the click event or by an actual hyperlink. -- Regards, Tom Ogilvy "Pablo Chemes" wrote in message om... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Call a subroutine using variable subroutine name | Excel Discussion (Misc queries) | |||
| SUBROUTINE HELP | Excel Discussion (Misc queries) | |||
| Every second subroutine | Excel Programming | |||
| How do I run a subroutine on a worksheet | Excel Programming | |||
| Usermenu does sometimes not find subroutine | Excel Programming | |||
Linear Mode
