Changing Cell Backround from Marco

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

davep1553 - 22 Jan 2006 08:06 GMT

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.

Signature

davep1553

Reply to this Message

Gary Keramidas - 22 Jan 2006 08:27 GMT

this would make a1 light blue

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

End Sub

Signature

Gary

> I need to know the command(s) to change the backround color of a cell
> from a VBA marco.
[quoted text clipped - 4 lines]
> too far off make a cell red so it's clear I should get the info to
> update this.

Reply to this Message