Solved

Disabling combobox1_click event

Posted on 2010-09-15
1
340 Views
Last Modified: 2012-05-10
I tried to disable the combobox1_click event through the following statements on the sheet module

        Application.EnableEvents = False
        ComboBox1.Clear
        Application.EnableEvents = True

But the event is still triggered. Why?

0
Comment
Question by:Saqib Husain, Syed
1 Comment
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 33680610
Because EnableEvents does not affect controls. You need to use a boolean variable which you set to True (or False depending on how you use it) and then have the first line of the Click event check the variable and exit if True.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VBA name newly created sheet 4 23
Auto Populate Day Month  2 digit Date 4 16
Excel Cell Total 3 20
Excel 2010:  Creating a "Yes" or "No" Pop-Up 20 37
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

776 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