command button color changed while cells value change and else...

Hi Guys,

I need your golden brain to write code:
1. how to change command button color while the cell value is changed "WITHOUT CLICK" in command button", by meant it will be updated automatically while the cell value is changed.
Lets say: if Cell: A5 = 0 then the command button = red, and if cell A5 = 1 then the command button = white
is it possible?

2. How to draw shape in userform?

3. How to write code from command buttons to change in the same cell value . Let's say if command button1_click: cell B5 = 0 and if command button2_click: cell B5 = 1

Thanks in advance
Iqballud

Hi John, thanks a lot for your answered.
1. The code is not working.
2. It's OK, i will try to find another way.
3. It's working fine.
Also i am tried to change the code Range to Cells, the commandButton1 the value is kept and the quote is removed, the commandButton2-the value was removed also the quote is removed. And all of this code are working too.
Is there any difference between Range and Cells? when i removed Value, this is working too, included while i am removed the quote.
Here is the code:
Private Sub CommandButton1_Click()
Cells(5, 2).Value = 0
End Sub
Private Sub CommandButton2_Click()
Cells(5, 2) = 1
End Sub

Thanks in advanced.
Iqbal

John, again big thanks to you.

Cheers.
Iqbal