View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Yajiv Yajiv is offline
external usenet poster
 
Posts: 9
Default 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