View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill[_27_] Bill[_27_] is offline
external usenet poster
 
Posts: 1
Default Tab between ActiveX controls on an Excel worksheet

When I place an ActiveX control (I'm using text boxes)
directly on a worksheet, properties that control tab
order (like tabindex) are not listed on the control's
property sheet. When I try to set the property
programtically, I get a "object does not support property
or method" error.

However, when I place the same controls on a user form
and use the same code, the property is listed, the
control works fine and tabs in the order I specify.

Is there any way to control the tab order for controls
placed directly on an Excel worksheet?

Thanks,
Bill