Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab between ActiveX controls on an Excel worksheet
"Bill" wrote ...
Is there any way to control the tab order for controls placed directly on an Excel worksheet? You have to roll your own using the control's events (e.g. _KeyDown), the worksheet's events (e.g. _SelectionChange) and maintain your own tab order for them to refer to. Jamie. -- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab between ActiveX controls on an Excel worksheet
Thanks Jamie - do you know of any references I could
consult? I found some helpful stuff on MSDN but nothing that dealt with this particular issue... TIA, Bill |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab between ActiveX controls on an Excel worksheet
that is because there is no supported concept of tabbing between controls on
a worksheet. when tabbing on a worksheet, you tab from cell to cell. It is not clear how you would signal that you wanted to tab between controls. See Rob Bovey's posting on a method to do this: http://groups.google.com/groups?thre...GP11.phx .gbl -- Regards, Tom Ogilvy "Bill Sullivan" wrote in message ... Thanks Jamie - do you know of any references I could consult? I found some helpful stuff on MSDN but nothing that dealt with this particular issue... TIA, Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activex controls in Excel 2003 | Excel Worksheet Functions | |||
Tab support for worksheet activex controls | Excel Programming | |||
tabbing through ActiveX controls on worksheet | Excel Programming | |||
Problems with worksheet containing ActiveX controls | Excel Programming | |||
ActiveX Controls on Excel sheets | Excel Programming |