Get tab name of active tab control

X

XP

Using Office 2003 and Windows XP;

I need to return the name on the Tab of the currently activated tab of a Tab
Control. I hope that makes sense; e.g. If I have five tabs and the one that
is currently showing is named "Index" then I need to return "Index".

By chance, has someone got a function that will do this?

Thanks much in advance.
 
S

Stuart McCall

XP said:
Using Office 2003 and Windows XP;

I need to return the name on the Tab of the currently activated tab of a
Tab
Control. I hope that makes sense; e.g. If I have five tabs and the one
that
is currently showing is named "Index" then I need to return "Index".

By chance, has someone got a function that will do this?

Thanks much in advance.
Click to expand...

Debug.Print Me.MyTabControl.Pages(Me.MyTabControl.PageIndex).Caption

(Untested. IOW made up on the spot! Ought to work, tho...)
 
M

Marshall Barton

XP said:
Using Office 2003 and Windows XP;

I need to return the name on the Tab of the currently activated tab of a Tab
Control. I hope that makes sense; e.g. If I have five tabs and the one that
is currently showing is named "Index" then I need to return "Index".
Click to expand...


This will return what is displayed on the tab:

TabCtl.Pages(TabCtl).Caption

If you have not specified the Caption, then this will return
the Name of the tab page:

TabCtl.Pages(TabCtl).Name
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

return Subform Name on Tab control 2
Page-Index of a Tab-Control from a SubForm 3
Subforms within a Tab control 4
referenceing tab control tabs(pages) 1
Tab Visibility 3
How to create a Header at the top of my MS Project 2013 plan? 3
current page index 2
tab control page selector tabs not visible when form opens 1

Top