ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   double click macros (https://www.excelbanter.com/excel-programming/418575-double-click-macros.html)

T-bone

double click macros
 
Hi

i have assigned macros to three oval objects
when you click on the first oval it turns it green and the other oval turn
grey
when you click on the second oval it turns it yellow and the other two turn
grey.
etc etc..

i wanted to somehow make it that when you double click on one of the ovals
that it
turn all three grey
i.e. reset them

please help

t

ShaneDevenshire

double click macros
 
Hi,

The problem here is that ovals don't have a double-click property and you
can only assign one macro to each oval.

Now if you replace the ovals with Control Toolbox command buttons you can
assign more than one macro to each button, because those buttons support
multiple event procedures.

--
Thanks,
Shane Devenshire


"T-bone" wrote:

Hi

i have assigned macros to three oval objects
when you click on the first oval it turns it green and the other oval turn
grey
when you click on the second oval it turns it yellow and the other two turn
grey.
etc etc..

i wanted to somehow make it that when you double click on one of the ovals
that it
turn all three grey
i.e. reset them

please help

t



All times are GMT +1. The time now is 12:55 AM.

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