Jim:

Please disregard my last post. I screwed on my head and looked beyond my
nose and now understand what you were saying. So now I've got the event to
trigger - Thanks so much for your help!

One follow-up question: Now that I can trigger the ctrlnew4_change event
from the class module, how do I reference the corresponding textbox
(ctrlnew6) which contains the corresponding price/ billing rate? In other
words, if at runtime I select "Supervisor" as the ctrlnew4 value, how do I
access and update the ctrlnew6 value? I've tried the following:

1. passing ctrlnew6 as an arguement from the standard module (where it's
created) to the class module (where it's changed)

2. Declaring ctrlnew6 as a public textbox at the top of the standard module
and as an event class at the top of the class module

In both cases, I get errors.

Any thoughts?

Thanks for your help and patience!

Jim

"JimRWR" wrote:

Jim:

I put the following line above the module (not the class module), but I keep
getting errors:

Dim ctrlComboBoxHandler As New ComboBoxHandler

Two questions:

1. Why is this bombing
2. Should this go above the class module or the module that is invoking the
class?

Thanks!

Jim

"Jim Rech" wrote:

When you create as class as type XXX you have to create handlers for the
events object type XXX recognizes. So after you put this:

Public WithEvents ctrlnew4 As MSForms.ComboBox

at the top of a new class module you next create those handlers by first
selecting "ctrlnew4" from the left drop down at the top of the module window
and then the specific event you want to code from in the right drop down. I
don't see any evidence you're doing that from the code you posted.

--
Jim