ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shapes used as selectors - highlighting (https://www.excelbanter.com/excel-discussion-misc-queries/249673-shapes-used-selectors-highlighting.html)

Steve

Shapes used as selectors - highlighting
 
I am using shapes with assigned macros as the selectors for my Sumproduct
criteria. So I have rectangle shapes with each person's name on them and
when I click on them they name is input into a criteria field on another
page. It works well, but is there any way to have the shape highlight or
change looks once I click on it so you can see which criteria has been
selected?

Thanks!


All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com