As long as you have a reference to MSForms library you should be able to do that. I got the following to compile:
Public WithEvents tbxTest As MSForms.TextBox
The problem you'll run into is that in class modules the menu of events is (for some reason I don't know) restricted. Looks like for a textbox control in a class module, the only events you'll be able to trap are:
[*]BeforeDragOver[*]BeforeDropOrPaste[*]Change[*]DblClick[*]DropButt*******[*]Error[*]KeyDown[*]KeyPress[*]KeyUp[*]MouseDown[*]MouseMove[*]MouseUp[/list]And change fires for every ruddy change, so it's tough to use. I've been working on similar problems. I'd love to be able to figure out a way to trap on Enter/Exit events on multiple textboxes at once, but I haven't figured out a good way (I ended up just using the VBIDE / VBComponent tools to insert a bunch of code into the userform - ugh). I also tried using a generic MSForms.Control object in a class module because that does give you Enter/Exit events. But VBA would not let me assign a textbox to that generic control. :x
If you do figure out a way to pull this off in a class module, do post back, I'd be interested in seeing it. Good luck.