Option Explicit
Private Sub CommandButton1_Click()
'your code to do all the work here
if somethinggoodhappened = true then
Me.CommandButton1.BackColor = &HFF00&
else
me.commandbutton1.backcolor = &HFF&
end if
End Sub


justbrewit wrote:

Suppose I have a spreadsheet that does a number of calculations. I have
a command button which I use to execute the solutions.

1. I would like the button to turn green (or some color) when the
solution has converged, which I can check at any time

2. If a change to any parameter is made (and thus the former solution
is not a solution for the new case) I would like to change the color,
to red for example.

i would appreciate it if someone could help me figure out how to
accomplish this, particularly the second part.

Thank you

--
justbrewit
------------------------------------------------------------------------
justbrewit's Profile: http://www.excelforum.com/member.php...o&userid=37539
View this thread: http://www.excelforum.com/showthread...hreadid=571792

--

Dave Peterson