creating a custom class event for worksheet textbox lostfocus

Hello all,

I haven't worked with class modules yet and need to create an event when a Worksheet textbox named "Input1" loses focus. When the user clicks out of the textbox I need to add a row to the active sheet after row 43. If this can be adapted to work with all textboxes, say by using the "ActiveShape" property, that would be even better.

Any help would be greatly appreciated!

Best,

Willardio

Try the built in EXIT event

Please Login or Register  to view this content.