ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Make a particular tab visible on a forms tab control (https://www.excelbanter.com/excel-programming/395722-make-particular-tab-visible-forms-tab-control.html)

Dale Fye

Make a particular tab visible on a forms tab control
 
How do I make a particular tab on a forms tab control the one that is visible?

I've tried

me.myTab = 0

me.mytab.page(0).setfocus


--
Email address is not valid.
Please reply to newsgroup only.

Dave Peterson

Make a particular tab visible on a forms tab control
 
On a tabstrip, you'd use:
Me.TabStrip1.Value = 2
(0 is the first, 1 the second, ...)

On a multipage control, you'd use:
Me.MultiPage1.Value = 2
(0 is the first, 1 the second, ...)

Dale Fye wrote:

How do I make a particular tab on a forms tab control the one that is visible?

I've tried

me.myTab = 0

me.mytab.page(0).setfocus

--
Email address is not valid.
Please reply to newsgroup only.


--

Dave Peterson


All times are GMT +1. The time now is 12:08 AM.

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