I have a dynamically created TabStrip. I know in order to reference dynamically created objects, I need to reference them like this:

myForm!Label1

But I'm not sure how to capture the click event of my TabStrip. I've been trying the following code with no success:

Private Sub (myform!TabStrip1)_click()

Can anyone help?

Dear dkr72,

In excel VBA help you find under Click Event the following syntax :

Private sub object_click(index as long) for an Multipage or tabstrip

If you double click on the tabstrip in VBA edit mode then automatically
the syntax : Private Sub Tabstrip1_Click(Byval Index as Long) is generated.

Succes