help on excel and vba

hi there
i really need help for VBA and i am desperate
i know nuts about VBA so i really appreciate if anyone is kind enough to show me the way,

i have used a few buttons on excel and assign micros to them

however, i would like to know how can i make the buttons change colour upon clicking, and make it exclusive

eg : Mood : "Good" "Bad"

once i click on "Good", it changes from blue to red, but once i click on "Bad",
it chages from blue to red , and "good" changes back from red to blue. and visa versa.

thanks a lot for your help
i do not even know what version of VBA i am using. It just based on excel 2003

 

The great thing about Microsoft is that they've documented everything on VBA! Please see this link for a complete listing of the Microsoft Excel object model. This has all the objects, methods and properties exposed by the Excel COM.

Check under 'Reference'. I'm willing to bet that there is a 'Color' property you can use to set the colour of the object in question. This gives you the syntax of using this property.