[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

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
0
dantastico
Asked:
dantastico
  • 6
  • 3
1 Solution
 
Martin LissOlder than dirtCommented:
How does this differ from your previous question?
0
 
Steven HarrisPresidentCommented:
Disregard the post...
0
 
Martin LissOlder than dirtCommented:
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.
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
Martin LissOlder than dirtCommented:
Did my suggestion help you?
0
 
dantasticoAuthor Commented:
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.
0
 
Martin LissOlder than dirtCommented:
A solution to the problem is attached. It involves a boolean variable I added named bAddingToList.

BTW if in the future you ever want to use EnableEvents there's no need to do Public EnableEvents As Boolean. EnableEvents is a built-in property of Excel so all you need to do is Application.EnableEvents = True (or of course False).
Q-28290075.xls
0
 
dantasticoAuthor Commented:
Hi Martin

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

Thanks very much.

Dan
0
 
Martin LissOlder than dirtCommented:
And so one final step:)
0
 
dantasticoAuthor Commented:
Perfect. That works a treat!

Thanks
0
 
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2013
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now