Referencing A Subprocedures Name (Re-post)
Here is the original post if it is of any help!
//////////////////////////////////////////////////////////
Here is an example of a subprocedure I am using... it is
used to convert an input into an integer.
Private Sub TextBox41_Change()
Dim linkedCell As String, cellValue As String
linkedCell = TextBox41.linkedCell
cellValue = TextBox41.Value
Call convert(linkedCell, cellValue)
End Sub
However, I am wanting to reference the name of the
subprocedure in which this code is being ran... so
instead
of having to type:
linkedCell = TextBox41.linkedCell
cellValue = TextBox41.Value
which is textbox specific I can simply reference the name
of the textbox through the sub's name, after having
deleted
the _Click part previous to the remaining code, ie.
something like
linkedCell = "sub.name".linkedCell
cellValue = "sub.name".Value
I have over 100 of these text boxes to edit and I dont
want
to be having to paste in all this code only to have to go
in and individually change the textbox numbers
specfically
for each textbox!
Thanks for any help.
Bryn.
|