Hi Tom,
I guess you would have to trigger off of something else
like a sheet change, or a calculation.

http://www.mvps.org/dmcritchie/excel/event.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"tom taol" wrote in message ...


i want to event handler..
please........

i want to Enter and Exit event of textbox in userform using class.
because, the number of textboxes in userform has many...

but, TextBox in class module Event don't have Enter and Exit.....

how ??????

*** Sent via Developersdex http://www.developersdex.com ***