Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referencing | Excel Discussion (Misc queries) | |||
referencing a different tab by referencing a list in the current s | Excel Worksheet Functions | |||
More referencing | Excel Worksheet Functions | |||
3-D referencing | Excel Discussion (Misc queries) | |||
Referencing | Excel Discussion (Misc queries) |