asked on

need to disablechange events for user form combobox

Hi

I have a combobox (at B3) which includes the option to select 'other'. In this case an input box appears to allow the user to add a business name to the combobox's linked list (at column BJ).

The problem is that the change to the list triggers the change event and the input box reappears.

I thought this was solved yesterday, but the solution (enable.events =false....etc) only worked once.

Any help would be much appreciated
Dantastico
Assessment-Input2.xls

Martin Liss

How does this differ from your previous question?

Steven Harris

Disregard the post...

Martin Liss

Oh, I didn't read your question all the way.

In any case you don't have enableevents = False anywhere in your code that you posted.

Martin Liss

Did my suggestion help you?

dantastico

ASKER

It worked once. Then it never worked again.
I have read that for user forms (Although I am just using a form control on the worksheet)you need to set me.enable as boolean...or something to that effect, but It's a little beyond me at the moment.

ASKER CERTIFIED SOLUTION

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dantastico

ASKER

Hi Martin

Yes.....Yes that's it!!!!! Awesome, you truly are a hero.

Thanks very much.

Dan

Martin Liss

And so one final step:)

dantastico

ASKER

Perfect. That works a treat!

Thanks

Martin Liss

You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2013