C
colin..
I am running vba 6 in excel 2000. I have attached code to an event, which
doesn't seem to always fire. I can only assume this is a bug. Are there any
other possibilities? And if it is a bug, is anyone in Redmond likely to
provide a fix?
I have a form with 2 controls on it: a CheckBox and a TextBox. Both of these
controls are bound to cells in a spreadsheet (using the ControlSource
property). The only code is:
Sub chkTestCheckBox_Click()
txtTestText = txtTestText + 1
End Sub
This adds one to the number in the text box every time the checkbox is
clicked EXCEPT the first time that it is clicked.
If either one of the controls is not bound to a cell in the spreadsheet it
works every time (even the first).
Or, if I set a breakpoint in the debugger on either of the first two lines
("Sub …" or "txtTestText …" then it fires every time. If I break on the last
line ("End …"), it doesn't fire on the first click.
Any thoughts?
doesn't seem to always fire. I can only assume this is a bug. Are there any
other possibilities? And if it is a bug, is anyone in Redmond likely to
provide a fix?
I have a form with 2 controls on it: a CheckBox and a TextBox. Both of these
controls are bound to cells in a spreadsheet (using the ControlSource
property). The only code is:
Sub chkTestCheckBox_Click()
txtTestText = txtTestText + 1
End Sub
This adds one to the number in the text box every time the checkbox is
clicked EXCEPT the first time that it is clicked.
If either one of the controls is not bound to a cell in the spreadsheet it
works every time (even the first).
Or, if I set a breakpoint in the debugger on either of the first two lines
("Sub …" or "txtTestText …" then it fires every time. If I break on the last
line ("End …"), it doesn't fire on the first click.
Any thoughts?