Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to setup MyTextBoxes class to handle data
validation of userform textboxes. My class module is as follows: Option Explicit Public WithEvents MyTextBox As MSForms.TextBox Private CurrValidation As Integer Property Get Validation() As Integer Set Validation = CurrValidation End Property Property Let Validation(ValType As Integer) CurrValidation = ValType End Property Private Sub MyTextBox_Change() MsgBox ("Change") End Sub Obviously I want to use MyTextBox_Exit event, but it is not listed in the event list in the class module (all the events are available except for AfterUpdate, Exit and Enter). Is there any workaround of this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Private Textbox Exit Sub question... | Excel Worksheet Functions | |||
How can I expose the TextBox BeforeUpdate event to my user class? | Excel Discussion (Misc queries) | |||
Capture event when exit Column G | Excel Discussion (Misc queries) | |||
Control Exit event | Excel Programming | |||
On Enter and On Exit events of MSFORMS controls? | Excel Programming |