Changing button colours with a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Any advice on this one - I am very inexperienced with the writing of macros, but have managed to write a few and attach them to buttons, I would like the buttons to change colour each time they are clicked - any suggestions??
 
VBA code:

Worksheets("Sheet1").Shapes(Button64).Select
With Selection.Font
.ColorIndex = 3
End With



Jim




Rinativers said:
Any advice on this one - I am very inexperienced with the writing of
Click to expand...
macros, but have managed to write a few and attach them to buttons, I would
like the buttons to change colour each time they are clicked - any
suggestions??
 
I bet you have Forms toolbar buttons? If so, I don't think you can. Control
toolbox buttons yes, forms no.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Rinativers said:
Any advice on this one - I am very inexperienced with the writing of
Click to expand...
macros, but have managed to write a few and attach them to buttons, I would
like the buttons to change colour each time they are clicked - any
suggestions??
 
Back
Top