Application.enable
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
|