Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
system variable representing subroutine name?
Take alook at
http://makeashorterlink.com/?E24351335 a.k.a., http://groups.google.com/groups?hl=e...p03%26rnum%3D1 "Mike Cooper" wrote in message om... Hi, I am trying to write code that accesses the .LinkedCell property of a checkbox, from the checkbox_Click subroutine of the checkbox. That is easy enough: Sub IssueABox01_Click() SomeVariable = IssueABox01.LinkedCell (Where IssueABox01 is the name of my checkbox.) Here is my challenge. I have 105 checkboxes and I would to create uniform code so I don't have to customize that code 105 times! What I need is some kind of default system variable that I can replace "IssueABox01" with in the second line above; a label or variable that represents the title of a subroutine (I can edit out the "_Click" after that. Or else the equivalent of the "Me" form variable for a currently selected object. I am new to VBA, but intuitively it just seems like such a variable has to exist. I mean we're "in" the subroutine right? So excel must "know" it's name! Can anyone out there tell me if such a variable, and if so, what it is. My books don't reference one, but then they are very basic. Thank you, Mike Cooper |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call a subroutine using variable subroutine name | Excel Discussion (Misc queries) | |||
How do I open an Excel file on XP system, saved on a Vista system | Excel Discussion (Misc queries) | |||
SUBROUTINE HELP | Excel Discussion (Misc queries) | |||
How to use this subroutine on multiple cells? | Excel Worksheet Functions | |||
How do I exit a macro subroutine? | Excel Worksheet Functions |