How can I expose BeforeUpdate events to my TextBox class?

[bereid]

After defining a new TextBox class with a statement like the following:

Public WithEvents tbox As MSForms.TextBox

I can select the tbox class from the object drop-down list in VBE, BUT
the BeforeUpdate event is not available in the procedure drop-down.
Many of the other TextBox events (Change, for example) are available,
but I would like to handle the BeforeUpdate event.

Can anyone help me figure out what do do to make the missing event(s)
available to my class?

Thanks VERY much for any help,
Bruce Reid

 

[Norie]

Bruce

I'm sorry but just don't think it's possible.

What exactly are you trying to do?

 

[bereid]

Hi Norie,

I have a collection of TextBoxes (28 of them), and as the user moves from box to box, entering values into each, I want to validate the input, and give immediate feedback if an illegal value is entered. I'm currently monitoring the Change event, and that works fine for characters typed. But if a box whose contents have been deleted (legal value, so long as the box isn't empty on loss of focus) loses focus, I want to be able to immediately complain that an empty value is illegal. I don't want separate event handlers for each TextBox, but none of the events available to my class seem to do the job.

Thank you for considering my dilemma. I'll look forward to hearing if you have any ideas that I can apply to solve this problem.

Regards,
Bruce