C
Craig Brandt
I must be missing something when it comes to buttons.
I have on on my "STRAT" sheet a button called StratAFBut. It's been declared
as a Public Button. When the system reacts to the button being depressed, I
can ensure that it is recognized by adding the following statement, before
I test the button:
Set StratAFBut = ActiveSheet.Buttons(Application.Caller)
I can then test the button without issue.
I have a routine embedded on the STRAT sheet that reacts to a double
click(DC) on a cell. The routine checks to make sure that the DC was in the
expected column, that the entry is the right format and that the button is
in a "ON" state. When I do the test:
If StratAFBut.Caption = "Turn AutoFocus On" Then Exit Sub
I get the following error:
"Object Variable or With Block variable not set"
The above "SET" will not work because the Button was not instrmental in
calling the routine.
How do I get the button recognized?
Thank for your patience with these questions,
Craig
I have on on my "STRAT" sheet a button called StratAFBut. It's been declared
as a Public Button. When the system reacts to the button being depressed, I
can ensure that it is recognized by adding the following statement, before
I test the button:
Set StratAFBut = ActiveSheet.Buttons(Application.Caller)
I can then test the button without issue.
I have a routine embedded on the STRAT sheet that reacts to a double
click(DC) on a cell. The routine checks to make sure that the DC was in the
expected column, that the entry is the right format and that the button is
in a "ON" state. When I do the test:
If StratAFBut.Caption = "Turn AutoFocus On" Then Exit Sub
I get the following error:
"Object Variable or With Block variable not set"
The above "SET" will not work because the Button was not instrmental in
calling the routine.
How do I get the button recognized?
Thank for your patience with these questions,
Craig