Hello everyone,

I have a userform that I am using as a wizard dialog. To clean up the code
a bit, I would like to use classes. I am having a problem implementing some
of the textboxes events in my class object. (Excel 2000)

in my class (cVehicles)

private withevents m_objMake as msforms.textbox

public property set Make(vData as msforms.textbox)
set m_objmake = vData
end property

'This is the event I would like to work with
'it is not available to me, anyone know what I need to do to be notified of
it?
'Since the dialog will have many controls on it, I would like to seperate
some of
'the logic out of the userform and into classes.
private sub m_objMake_Exit(ByVal Cancel as MSForms.ReturnBoolean)
debug.print "Leaving Make..."
end sub

I am afraid that is just the way that it is. Some events are not exposed
using this technique.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"AMDRIT" wrote in message
...
Hello everyone,

I have a userform that I am using as a wizard dialog. To clean up the
code
a bit, I would like to use classes. I am having a problem implementing
some
of the textboxes events in my class object. (Excel 2000)

in my class (cVehicles)

private withevents m_objMake as msforms.textbox

public property set Make(vData as msforms.textbox)
set m_objmake = vData
end property

'This is the event I would like to work with
'it is not available to me, anyone know what I need to do to be notified
of
it?
'Since the dialog will have many controls on it, I would like to seperate
some of
'the logic out of the userform and into classes.
private sub m_objMake_Exit(ByVal Cancel as MSForms.ReturnBoolean)
debug.print "Leaving Make..."
end sub

If the event is available to you, it is shown in the right dropdown.

Events such as Exit and BeforeUpdate are not native to the Textbox. They
are provided through the Control container object and as far as I know, you
can not use those events in your class module.

--
Regards,
Tom Ogilvy

"AMDRIT" wrote in message
...
Hello everyone,

I have a userform that I am using as a wizard dialog. To clean up the
code
a bit, I would like to use classes. I am having a problem implementing
some
of the textboxes events in my class object. (Excel 2000)

in my class (cVehicles)

private withevents m_objMake as msforms.textbox

public property set Make(vData as msforms.textbox)
set m_objmake = vData
end property

'This is the event I would like to work with
'it is not available to me, anyone know what I need to do to be notified
of
it?
'Since the dialog will have many controls on it, I would like to seperate
some of
'the logic out of the userform and into classes.
private sub m_objMake_Exit(ByVal Cancel as MSForms.ReturnBoolean)
debug.print "Leaving Make..."
end sub