Changing Cell Backround from Marco

[davep1553]

I need to know the command(s) to change the backround color of a cell from a VBA marco.



Not Important but I feel like typing
I'm writing code into the change event of a spreed sheet to automaticly compare a few dates refer to when things have happened and if they get too far off make a cell red so it's clear I should get the info to update this.

[Gary Keramidas]

this would make a1 light blue

Sub test()
Range("a1").Interior.ColorIndex = 37

End Sub

--


Gary


"davep1553" <[email protected]> wrote
in message news:[email protected]...
>
> I need to know the command(s) to change the backround color of a cell
> from a VBA marco.
>
>
>
> Not Important but I feel like typing
> I'm writing code into the change event of a spreed sheet to automaticly
> compare a few dates refer to when things have happened and if they get
> too far off make a cell red so it's clear I should get the info to
> update this.
>
>
> --
> davep1553
> ------------------------------------------------------------------------
> davep1553's Profile:
> http://www.excelforum.com/member.php...o&userid=28517
> View this thread: http://www.excelforum.com/showthread...hreadid=503751
>