_Change

[User4Fun]

I have a code to display a msg box when
rivate Sub MainTestComboBox_Change()

it is a simple msgbox "things change"

but it is not working?? any ideas why?

 

[SkipVought]

Huh?

msgbox "things change"

works for me???

your code fragments do not make sense!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[electricpete]

Is the name (not caption) of the box still MainTestComboBox ?

Where is the combobox located in... sheet or userform?

Maybe you left the userform design mode active?

Do other events work? (MainTestComboBox_Click()

 

[Andrzejek]

If your MainTestComboBox's Style is a DropDownList, you will never get to MainTestComboBox_Change Event because you can not type in this combo box, you can just choose your entry.

Have fun.

---- Andy

 

[fumei]

User4Fun, statements like:

but it is not working?? any ideas why?

simply do not tell us enough.

Would YOU know what it means if someone stated that?

You supply no code, nor any idea of where this is happening. You do not tell us what "not working" even means. It sort of works, but you get error messages? It does not work at all?

Please try again, and give actual details.

faq219-2884

Gerry
My paintings and sculpture