G
Guest
What VB script is needed to, say, change the colour of a control button say
from gray to red when it is clicked.
I've tried using the scripts given in:
http://www.mrexcel.com/archive/Controls/5034.html
but nothing is happening when the button is clicked - if I format it as grey
and click it, then it stays gray, if I format it as red and click it, it
stays red. I would like it to change to red when clicked and remain gray
when not clicked - it must be possible!
many thanks
from gray to red when it is clicked.
I've tried using the scripts given in:
http://www.mrexcel.com/archive/Controls/5034.html
but nothing is happening when the button is clicked - if I format it as grey
and click it, then it stays gray, if I format it as red and click it, it
stays red. I would like it to change to red when clicked and remain gray
when not clicked - it must be possible!
many thanks