Using "Enter" procedure for a Class control

**AdLoki** · 01-14-2015, 07:10 AM

Hi All,

I have a Class Module from which a set of TextBox controls are dynamically created in a UserForm. It is all working fine but I don't seem to be able to create a declaration that will trigger when the TextBox is entered or exited.

For a standard TextBox created manually in a UserForm you can add a Private Sub txtbox_Enter() procedure but there isn't the option for this declaration in the Class Module.

Any thoughts?

Thanks,
Ad

**Norie** · 01-14-2015, 07:14 AM

Ad

The Enter, and Exit events for a textbox controls aren't available in a class I'm afraid.

What is it you are trying to do on entering the textbox(es)?

**AdLoki** · 01-14-2015, 12:59 PM

Hi Norie,

I had a feeling this was the case :/

Basically I'm trying to make it such that when a text box is entered, the contents is cleared of all formatting - for instance a text box with value "£ 1,234.50" will switch to "1234.50" when entered and then the value will be re-formatted again on exit.

Any thoughts on another way to achieve this?

Thanks!
Ad