• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Enhancing Your Pivot Table R... > Creating a User Interface with Form ...

Creating a User Interface with Form Controls

Making your clients run your macro with shortcut keys, such as Ctrl+Shift+R, can be a satisfactory solution if you have only one macro in your pivot table report. However, suppose you want to allow your clients to perform several macro actions. You will want to give your clients a clear and easy way to run each macro without having to remember a gaggle of shortcut keys. A basic user interface provides the perfect solution. You can think of a user interface as a set of controls such as buttons, scrollbars, and other devices that allow a user to run macros with a simple click of the mouse.

It just so happens that Excel offers a set of controls designed specifically for creating user interfaces directly on a spreadsheet. These controls are called form controls. The general idea behind form controls is that you can place one on a spreadsheet and then assign a macro it—meaning a macro you have already recorded. After a macro is assigned to the control, that macro is executed, or played, when the control is clicked. Form controls can be found on the Forms toolbar. To get to the Forms toolbar, go up to the application menu and select View, Toolbars, Forms.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint