Need Help on VBA

[golfduke]

I am using excel 2000.
How do I Change the Format of Bold and an Alignment Horizontal to "Left indent" and the Indent to the value of another field?
This needs to happen for a range of rows. It can be variable at any given time.

So if Field b2=2 I want to set field A2 to Bold and Horizontal of Left Align and Indent of 1-B2 (so indent of 1).
Conditional formatting does not do it.
I am not familiar with VB enough to do this by myself.

Thanks

Steve

 

[Michael M]

Hi Steve
I'm no expert in VBA either.
But this will do the trick.
However, I'm sure there will be others that will provide far better results.

Sub Macro1()
    If Range("A2").Value = 2 Then
    Range("A1").Select
    With Selection
        .HorizontalAlignment = xlLeft
        .AddIndent = False
        .IndentLevel = 1
    End With
    With Selection.Font
        .Name = "Arial"
        .FontStyle = "Bold"
        .Size = 10
    End With
End If
End Sub

Regards
Michael M