Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Disabling combobox1_click event

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
Saqib Husain, Syed
Asked:
Saqib Husain, Syed
1 Solution
 
Rory ArchibaldCommented:
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

Hire Technology Freelancers with Gigs

Work with 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.

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