Color Correction

[Aeneren]

Hello All,

Could some one point me in the direction of a list that would show the Numerical value for colors that the VBA usese in Excell.....

I have the code below that changes the Button Back Color to Red untill certain fields are filled in and then it changes to Yellow or Green. Problem is it changes it to a Pink more than Red so Im looking for the Numerical for RED.

Please Login or Register  to view this content.

Thanks Again,
Aeneren

[JieJenn]

Would Case 0: Me.CommandButton1.BackColor = vbred work?

[Aeneren]

JieJenn

Would Case 0: Me.CommandButton1.BackColor = vbred work?

Tried that before, and i just tried it again and still errors out.

Aeneren

[watersev]

hi Aeneren, try this option:

Please Login or Register  to view this content.

[Aeneren]

Watersev,

Thanks Worked now i have Red Buttons instead of Pink

Thanks
Aeneren