Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
object.EnableEvents = false
As we have application.enableevents = false where we can disable the
application events...is there a similar way to disable object events.... For example in the below example : I am looking for that every time the item is removed from the combobox/listbox it should not go to combobox/listbox change event. Sub unpopulate_ListBoxes(ByRef listbox_Name As ComboBox) Dim I As Integer If listbox_Name.ListCount 0 Then For I = 0 To listbox_Name.ListCount - 1 listbox_Name.RemoveItem (listbox_Name.ListCount - 1) Next I End If End Sub -- Ajit |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
object.EnableEvents = false
No, you need to create a variable and set that and test it in code.
-- HTH RP (remove nothere from the email address if mailing direct) "Ajit" wrote in message ... As we have application.enableevents = false where we can disable the application events...is there a similar way to disable object events.... For example in the below example : I am looking for that every time the item is removed from the combobox/listbox it should not go to combobox/listbox change event. Sub unpopulate_ListBoxes(ByRef listbox_Name As ComboBox) Dim I As Integer If listbox_Name.ListCount 0 Then For I = 0 To listbox_Name.ListCount - 1 listbox_Name.RemoveItem (listbox_Name.ListCount - 1) Next I End If End Sub -- Ajit |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.EnableEvents | Excel Worksheet Functions | |||
application.EnableEvents | Excel Discussion (Misc queries) | |||
application.enableEvents | Excel Programming | |||
Application.EnableEvents | Excel Programming | |||
Stopping the use of enableevents | Excel Programming |