VBA to change cell fill color

[andrewb90]

Hello all,

I'm a bit stumped with this. I am trying to create a macro that when I click on a button the fill color will change to yellow (or orange, or red, etc) I am not trying to change the fill color of an object or a specific cell, I just want to change the fill color so that I can click on a cell then fill it in myself.

Any help would be greatly appreciated! (I hope I made sense)

 

[sheetspread]

something like:

selection.interior.colorindex = 6


The toolbar has this button too, with a visual dropdown selection for all colors