How to detect number of characters in a textbox userform.

[omairhe]

Hello,
How can I detect the number of characters currently being typed in a userform's textbox1.
So if I type ABC then I run my code as soon as C is being typed in the textbox.

Will appreciate a lot.

 

[fadee2]

hi,
you can try

sub textbox1_change()
if len(textbox1.text)=3 then
'your code here
else
'another code here
end if
end sub

hth...

 

[omairhe]

hi,
you can try

sub textbox1_change()
if len(textbox1.text)=3 then
'your code here
else
'another code here
end if
end sub

hth...

this is perfect..
thanks so much.

 

[fadee2]

you are very welcome and thanks for feedback...