Use the Slicer (Worksheet_PivotTableUpdate) - creates a named range, based on the pivot table’s data body rangeĪlexJ created this pop up selector technique for his Excel files at work, so that people could make print selections.Select a cell (Worksheet_SelectionChange) - hides the special image, and calls the macro named “ShowDialog”, which shows the grouped Slicer shape.The Demo sheet also has worksheet events that run when you: The pivot table’s data body range is named when the pivot table updates, and that range is used to get the list of items. There’s also a Pivot Table, based on that Excel table, and the Slicer shows the items in the pivot table’s Selector field. In the workbook, AlexJ has an Excel Table, with a list of items required for the pop up selector. Those buttons have macros assigned, and there’s a bit of worksheet code too. The Slicer is sized to leave empty space at the bottom, and that’s where the other shapes are added, formatted to look like buttons. The pop up selector is an Excel Slicer that is grouped with other shapes. There are more details below, and the sample file is on the Excel Popup Slicer Selector page on my Contextures website. To see a longer version of how the Pop Up Slicer works, watch this video. This is a simple example – you could make the code do something fancier. Click the button to make the selector appear, select items from the list, then click to show a message or image. This animated screen shot shows how the pop up selector works. To get the benefits of a Slicer, without the real estate cost, AlexJ made this Excel Pop Up Selector – it’s hidden until you click the small button on the sheet, and disappears again, after you use it. Slicers make it easy to select from a list of items, but they take up valuable space on your worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |