Run Code When Tab Key Is Pressed (Or UserForm TextBox Is Activated)?

[indi visual]

I'm using Private Sub TextBox1_Change()


But it processing too much code for every letter I type.


I was thinking perhaps using TextBox1_Activate() but nothing happens.


I just thought it'd be nice to run my code from box to box instead of refreshing the code after every single key stroke.


As always any help is greatly appreciated.

 

[Luke M]

Why not use the LostFocus event? That way you can type whatever you want, and then when you're done and "move on", the macro will run?

[pre]

Private Sub TextBox1_LostFocus()
'Do something
End Eub

[/pre]