Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When I change a value in a combobox, say 16th combobox
why is that 15 and then 14 code also run at the end of 16. This is written in excel 2003 vba. why applications.enableevents = false is not working Any help is greatly appreciated. MVM ---------------------------- code ------------- Private Sub cmbGrade14_Change() Call blockDataEntry(cmbGrade14, 14) End Sub Private Sub cmbGrade15_Change() Call blockDataEntry(cmbGrade15, 15) End Sub Private Sub cmbGrade16_Change() Call blockDataEntry(cmbGrade16, 16) End Sub public sub blockDataEntry(c as combobox, r as integer) Application.enableEvents = False ........ Application.enableEvents = true End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW TO DO ENABLE ENABLE THE QUERY PARAMETER BUTTON? | Excel Worksheet Functions | |||
Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen) | Excel Programming | |||
Replace application.RTD property by Application.RTDServers collect | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming | |||
application.quit will not shut off application | Excel Programming |