ActiveX TextBox

[Maxlond]

I have a problem with my macro that runs in UserForm and I would also like to apply it to sheet1 in textBox active controls. I have a question how to change the code to work in sheat1?

Please Login or Register  to view this content.

[Andy Pope]

The Exit event is not available on the worksheet so use the LostFocus event instead.

Please Login or Register  to view this content.

Code should be within the worksheet object holding the control