Mastering Excel: User Forms by Mark Moore

Author:Mark Moore
Language: eng
Format: mobi, epub, pdf
Tags: Excel
Published: 2015-03-08T22:00:00+00:00

This exercise will center on this phrase:

The x largest customer is y

You will use a pin button to let the user determine how much the nth largest customer purchased (5th largest, 3rd largest, etc.). You will also get practice on how to combine formula results with text.

1 - Click the Spin Button worksheet.

2 - Click the spin button (Developer tab > Insert).

3 - Click and drag the cross-hair to create the spin button

4 - Right-click the spin button, and then click “Format Control.”

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.