Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable combo change event temporaraly
Application.EnableEvents = False
With ActiveSheet.ComboBox1 .ListIndex = 0 'this line does not seem to disable 'Private Sub ComboBox1_Change() .Visible = True .Activate End With how can i remedy this pleas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable combo change event temporaraly
Use
Application.EnableEvents = False and Application.EnableEvents = True around the code in the first procedure. Then set up the other procedure like this: Private Sub ComboBox1_Change() If Application.EnableEvents Then ' code here only runs if EnableEvents = True End If End Sub - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "sunilpatel" wrote in message ... Application.EnableEvents = False With ActiveSheet.ComboBox1 .ListIndex = 0 'this line does not seem to disable 'Private Sub ComboBox1_Change() .Visible = True .Activate End With how can i remedy this pleas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combo box change event | Excel Programming | |||
how to disable listbox change event | Excel Programming | |||
Disable Change Event in Form | Excel Programming | |||
Help with a Combo Box Change Event | Excel Programming | |||
Disable Worksheet change event | Excel Programming |