Macro run after user finish input text box

Hi expert,
I hava a text box on a userform.
i would like to ;
1) once userform done/ input data in userform , macro run.
ex: if user input "start" in text box, after 2 second ( whihc is done input value), macro automaitcally run without pressing any button or key.

please advise.....

Hi celticpucca, try using the Change property. For example, if the name of your text box is txtBox add the following code to your userform:

Please Login or Register  to view this content.

I hope that's what you need, otherwise let us know.

hi inesi,
how about if the user input others value ? such as "F99827BHG" or " 1234ABC"?
and i want it to run automactically after it done input.?

Hi Celticpucca, in this case try the code below. Please notice this code is not case sensitive and you would need to start the strings in lower case as I am using the function LCase in the Select Case. If you need to make it case sensitive remove the LCase and enter the strings the way you need (case "XXXxxxXXX", for example):

Please Login or Register  to view this content.

Good luck

hi all,
i had modified the code

Please Login or Register  to view this content.

if my relabtext = "", it will do nothing/ dont run macro. if relabtext<> "", which is i done input data, it will run macro "run1".
But my problem is, i did not finish input the data, my macro run. ex: i want to type "start", but, when i type the letter "s", it automtatically run without wait until i finish it...
please help...

hi,
i had attached the file.
it seem like to code loop thru many time...
when i add value < 9 character, the msg box appear more then 4 times. after click ok for 4 times. its ok...
please help....