Macro Help Pleaseee...

[bulldaddy1]

Good morning!

Can anyone please help me with a Macro that will format a border (one single dark line on the bottom of each cell) everytime there is a change in the cell value.

Thank you very much for your help!

 

[doofusboy]

You mean something like this?

Private Sub Worksheet_Change(ByVal Target As Range)
    With Target.Borders(xlEdgeBottom)
        .LineStyle = xlContinuous
        .Weight = xlThick
    End With
End Sub

 

[SteveO59L]

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Borders(xlEdgeBottom).LineStyle = xlContinuous
End Sub

 

[bulldaddy1]

Thanks a lot for the reply people!!!!

As you could probably tell, I know NOTHING about macros...so do I just copy and paste the marco into my spreadsheet, or do I have to name it first.

Thanks a lot for your help!

 

[SteveO59L]

Right-click on the sheet tab, and select the view code option.

In the window that opens change the options to "Worksheet" and "Change".

Then paste the code between the Private Sub and End Sub lines

 

[bulldaddy1]

This Monday is turning out to be okay! I think I am almost there...but perhaps I didnt fully explain my request for help.

lets say I have data in column A...and the first five rows equal "1", then in cell A:6 the value changes to 2". I would like the cell format to reflect a dark like between the cells where the values changed.

thank you for your patience.

 

[SteveO59L]

How do the values change ?

i.e user input, calculation from another sheet, automated dump??

 

[bulldaddy1]

Yes sir..."Auto Dumped"

 

[SteveO59L]

I shall have to have a think about that.

 

[bulldaddy1]

Thank you SteveO...no rush!