ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   multipage tabindex (https://www.excelbanter.com/excel-programming/343815-multipage-tabindex.html)

JT

multipage tabindex
 
One more question on multipage forms. I have a 4 page multipage form. I
have a change event where I set the tabindex on every control on each page.
This works great except that with one exception. After it tabs through all
of the controls, it tabs to the page name. Is there a way to prevent it from
doing this? I just want it to tab through the controls and not the actual
page tab as well.

Thanks again for all of the help............
--
JT

Leith Ross[_117_]

multipage tabindex
 

Hello JT,

The MulitPage control class doesn't expose the TabIndex property for
given Page in VBA. So you can avoid tabbing back to the Page name.

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=47926


Leith Ross[_118_]

multipage tabindex
 

Hello JT,

The MulitPage control class doesn't expose the TabIndex property for
given Page in VBA. So you can't avoid tabbing back to the Page name.

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=47926


Tom Ogilvy

multipage tabindex
 
If you aren't going to use the tabs (an assumption), why not make them
disappear.

Multipage1.Style = fmTabStyleNone

--
Regards,
Tom Ogilvy

"JT" wrote in message
...
One more question on multipage forms. I have a 4 page multipage form. I
have a change event where I set the tabindex on every control on each

page.
This works great except that with one exception. After it tabs through

all
of the controls, it tabs to the page name. Is there a way to prevent it

from
doing this? I just want it to tab through the controls and not the actual
page tab as well.

Thanks again for all of the help............
--
JT




Leith Ross[_120_]

multipage tabindex
 

Hiding the tabs would defeat the purpose of the control being a
Multi-Tab, would it not?

Leith


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=479268


Tom Ogilvy

multipage tabindex
 
If the purpose is to have the user make the selection of which page is
visible, then yes. But there are many other purposes for a multitab. If
movement between tabs (such as a wizard) is controlled by code, then hiding
the tabs may be a plus.

--
Regards,
Tom Ogilvy

"Leith Ross" wrote
in message ...

Hiding the tabs would defeat the purpose of the control being a
Multi-Tab, would it not?

Leith


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:

http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=479268





All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com