I have a UserForm with a Multipage control that has 3 pages. I want to change
the page order of the control when I access the UserForm from different
sheets in my workbook. i.e. MultiPage1 has 3 pages (Cashier, Tender,
Journal). If I access UserForm from Tender worksheet, I want the Tender page
of the MultiPage1 control to be in the 1st position. If accessing the
UserForm from the Journal worksheet I want the Journal page of the MultiPage1
control to be in the 1st position. What code can I use when running
UserForm1.Show to change the page order as described above?

Thanks in advance for any help given.

Sam