If the UserForm for Sheet("ORDERS") is in the same workbook as sheet("INTRO")
then in the sheet("INTRO") code module use:

Private Sub Worksheet_Activate()
itemqty.Show
End Sub

You will need to do a Unload itemqty somewhere in your code to remove the
form when you have finished with it.

You also need to ensure that the underlying code of the UserForm and it's
controls will operate properly from the different worksheet.

If the two sheets are in different workbooks, then you will have to copy the
form from the VBA module of one workbook to the VBA module of the different
workbook and then enter the code as described above.

"WLMPilot" wrote:

I have a workbook with three worksheets (INTRO, ORDER, ITEMS). The meat of
the workbook is with Orders, and I have everything working correctly on that
sheet. However, I need a userform that is used on ORDERS to be displayed on
INTRO when the workbook is opened or when the INTRO page is clicked on, ie
becomes active sheet. The INTRO sheet is used for the sole purpose of
providing instructions for the various sections used on worksheet ORDERS.

The userform name that I need is "itemqty"

Thanks,
Les