Increase the number of tab strips that appear on a VBA form

[taylo40]

hello,

I am in the process of trying to learn VBA and would appreciate some held regarding the user forms in Excel.

I have created a user form and then added a 'tab strip'. Excel then shows two tabs on the user form.

Is it possible to show more tabs on the form ?

Cheers

Jamie

 

[combo]

Select tabstrip, and next click it again. You should see thicker selection frame. Right-click tabstrip, the context menu should display 4 items: 'New page', 'Delete page', 'Rename...' and 'Move...'.
Similar action for multipage, properties window in this case displays page properties.

combo

 

[taylo40]

Thanks for you prompt reply.

Cheers

Jamie