During exit, and after save occurs, I get "Compile error: Variable not defined". The VS window appears, and the name of one of my form controls is highlighted. There are four ActiveX form controls on the worksheet: two labels and two drop-down lists, and event handlers for the drop-downs. A different control name can be highlighted on different exits
Why is there compilation at this point? What can I do? Here is sample code, I can see ddlYear or lblDept flagged.
Private Sub ddlDept_Change()
If m_bolBlockEvents = True Then Exit Sub
If IsNull(ddlDept.Value) Or ddlDept.Value = "" Then
lblDept.Caption = "All"
Else
lblDept.Caption = ddlDept.Text
If ddlYear.Value = "" Then
lblYear.Caption = "All"
End If
End If
...
Bookmarks