Show Specific Info in Tabbed Excel UserForm

To show instructions to users in your Excel files, you can addworksheet  comments or text boxes with notes.

text boxes with notes
text boxes with notes

Excel UserForm With Help Info

Another option is to put the notes in an Excel Userform, and add a Help button on each worksheet.

The button can open the Help form to a specific page, and show the relevant Help information.

UserFormHelp02

Worksheet Help Buttons

This screen shot shows the UserForm Help page that open when you click a Help button on a worksheet.

In this example, the PivotSales sheet is active in the workbook, and its Help button opens the Pivot page in the UserForm’s MultiPage control.

UserForm opens at specific tab

Download the Sample File

You can download the sample file, and see the written steps, on the UserForm MultiPage Help page, on my Contextures website.

Watch the Video

To see the steps for creating the UserForm and Help buttons, you can watch this Excel video tutorial.

__________

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.