[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

need to disablechange events for user form combobox

Posted on 2013-11-09
10
Medium Priority
?
180 Views
Last Modified: 2013-11-22
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
Comment
Question by:dantastico
  • 6
  • 3
10 Comments
 
LVL 50

Expert Comment

by:Martin Liss
ID: 39636380
How does this differ from your previous question?
0
 
LVL 18

Expert Comment

by:Steven Harris
ID: 39636388
Disregard the post...
0
 
LVL 50

Expert Comment

by:Martin Liss
ID: 39636392
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 50

Expert Comment

by:Martin Liss
ID: 39655414
Did my suggestion help you?
0
 

Author Comment

by:dantastico
ID: 39655737
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
 
LVL 50

Accepted Solution

by:
Martin Liss earned 2000 total points
ID: 39656851
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
 

Author Comment

by:dantastico
ID: 39656974
Hi Martin

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

Thanks very much.

Dan
0
 
LVL 50

Expert Comment

by:Martin Liss
ID: 39657033
And so one final step:)
0
 

Author Closing Comment

by:dantastico
ID: 39668368
Perfect. That works a treat!

Thanks
0
 
LVL 50

Expert Comment

by:Martin Liss
ID: 39669370
You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2013
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question