View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Activate an activex control on a sheet in excel 97?

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!