Make a tab active on a multi page

[tony.reynolds]

I have a WB with a user form that ive been working on for Purchace Orders and keeping track of inventory with three tabs on a multipage

I have #1 tab that has the current order in progress that allows me to select a supplier, select parts from that supplier and delivery method ETC

I have #2 Tab that allows me to Find/edit/create Supplier information

And a #3 tab that allows me to Find/Edit/create Parts Information

What id like is to be able to have an 'EDIT' button beside each part entered on #1 tab to be ordered that simply activates the #3 tab and then I'd write the code that enters the part description into the search box on tab #3 which invokes the rest of the data to be entered ready for editing

Simple but cant see how to do it

 

[Tom Urtis]

Assuming your multipage is named MultiPage1, the code to activate the third tab is

MultiPage1.Value = 2

Pages start at index 0 and increment by 1, which is why to VBA, the third multipage is #2.

 

[tony.reynolds]

Thanks I new it would be simple as.

Cheers