Which Page on a tab Control

[DaveFitton]

How programmatically can you tell which page on at tab control you have clicked on (using 'On Change' event?)

 

[FancyPrairie]

Assume the name of your tab controls is TabCtrl, then check TabCtrl.Value

 

[PaulF]

you can tell by the Page Index property of the each page. The index is zero based so tab page 1 is 0 in the index and tab page 2 is 1 in the index etc... this example displays a message box during the Change event of the tab control named TabCtl0

Private Sub TabCtl0_Change()
MsgBox "On Tab Index " & Me.TabCtl0
End Sub

HTH
PaulF