A better way to reference tab control pages

In VBA, a common way to refer to the pages of a tab control is to use the Value property. However, Luke Chung, President of FMS Inc., recommends using the PageIndex property instead. Click here to find out why!

tabs

Send your Power Tips to Mike and Chris at accpower@microsoft.com.

Office Blogs Comments

Comments: (2) Collapse

  • I see what he's saying but I would just be careful about my reference and stick with the tab reference.

  • With PageIndex I never had any problem. It's a safe way to re-arrange tabs if you use PageIndex - just don't rename the tabs.

Comments

Comments: (loading) Collapse