pegbol
05-14-2005, 07:53 AM
.
.
Hello,
How can change the text and color of an autoshape when click and run a macro ?.
Example:
When clik button (Letter A) insert A in cell B3, and change the color and text of the same button to color green and text (Letter B).
Then, the next time when click button (Letter B) insert B in cell B3, and change the color and text of the button to color red and text (Letter A).
All with the same button.
I enclose a file with my example.
Thanks in advance for your kind help.
best regards,
Pedro
.
.
.
Hello,
How can change the text and color of an autoshape when click and run a macro ?.
Example:
When clik button (Letter A) insert A in cell B3, and change the color and text of the same button to color green and text (Letter B).
Then, the next time when click button (Letter B) insert B in cell B3, and change the color and text of the button to color red and text (Letter A).
All with the same button.
I enclose a file with my example.
Thanks in advance for your kind help.
best regards,
Pedro
.
.