Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to refer to the .text property without text box name?
I have a textbox called txtNew.
How can i use the .text property without actually typing txtNew.text? I dont want to use "with" statement. is there any way to refer like "this.text"? (so that i can use those statements for all the textboxes, if necessary) Sub txtNew_Change ....some statement this.text ....some statement End sub sub txtNew1_Change ....some statement this.text ....some statement End sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
refer a cell text in b1 and extract remaing text from a1 | Excel Discussion (Misc queries) | |||
refer to text | Excel Discussion (Misc queries) | |||
How can I refer to a worksheet using text in a cell? | Excel Discussion (Misc queries) | |||
Excel VBA: Worksheet cell .Text property: 1024 bytes text len limit | Excel Programming | |||
How do i refer to the text typed in a combobox? | Excel Programming |