Change fill color after input automatically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bobocat - 30 Jun 2006 04:45 GMT

Hi

Do you have any suggustion for the following task.
I will make new entries to the excel list frequently. I hope that after I
input something in column A, the fill color of the entire row will change
automatically to indicate that it is a new enter. And before I close the
file, I will change back the fill color to transparent.

I recoreded a macro to change the fill color, but how can I run this macro
when I finsih input data in Column A (every worksheet)?

With best regards,
Bobocat

Reply to this Message

Scoops - 30 Jun 2006 09:32 GMT

> I recoreded a macro to change the fill color, but how can I run this macro
> when I finsih input data in Column A (every worksheet)?

Hi bobocat

Right-click the tab of a worksheet and click View Code.

Paste this in vb editor

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Target.EntireRow.Interior.Color = vbRed 'or whatever colour you
wish
End If
End Sub

Double-click ThisWorkbook and paste this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim wks As Worksheet
For Each wks In Worksheets
wks.Cells.Interior.ColorIndex = xlNone
Next
End Sub

Regards

Steve

Reply to this Message

Bobocat - 30 Jun 2006 15:37 GMT

thank you.

>> I recoreded a macro to change the fill color, but how can I run this
>> macro
[quoted text clipped - 25 lines]
>
> Steve

Reply to this Message