Using Excel 2003 you can place the following code into the keydown event of
an activex control and it works, but it produces an error message in excel 97.

me.oleobjects("CheckBox2").activate

Any help with this would be very much appreciated.

Thanks!

I assume you are running that code from the click event of another ActiveX,
or while another ActiveX has focus. In XL97 you would need to deselect
before trying to select another, or indeed before doing many other things
come to that. If you REALLY need to activate your checkbox try preceding
with:

Activecell.activate
me.oleobjects("CheckBox2").activate

Be aware that controls that have focus lead to all sorts of problems in
XL97, not only the problem you've encountered.

Regards,
Peter T

"VLONC7109" wrote in message
...
Using Excel 2003 you can place the following code into the keydown event
of
an activex control and it works, but it produces an error message in excel
97.

me.oleobjects("CheckBox2").activate

Any help with this would be very much appreciated.

Thanks!