How to identify TabControl index?

Private Sub tabTools_Change()
Debug.Print Me.tabTools.Pages.Item(0)
End Sub

This always prints 0. How do I get the Tab/Page that is clicked, or better
yet, that is currently active?

Thanks in advance.

re: How to identify TabControl index?

>[color=blue]
>Private Sub tabTools_Change()
> Debug.Print Me.tabTools.Pages.Item(0)
>End Sub
>
>This always prints 0. How do I get the Tab/Page that is clicked, or better
>yet, that is currently active?
>[/color]

Try this:

Private Sub Tabtools_Change()
Debug.Print Me!Tabtools.Value
End Sub


Remember that the first one is 0, and they go up from there.

HTH

Jan
Jan Stempel
Stempel Consulting