Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Tabindex | Excel Worksheet Functions | |||
TabIndex property | Excel Programming | |||
vba - using multipage | Excel Programming | |||
Multipage | Excel Programming | |||
Multipage | Excel Programming |