Change row content via macro

[Corleone]

I would like to if possible to run a procedure that replaces anything in the
selected row(S) with "TBD" but only in the following columns C,D,E,F,G,H,& I.

if possible i would also like it to work when the macro is run, if any cell within that row is selected, rather than the user having to select to full row,

Any help is appreciated

Ive tried relative referencing but was unable to work out how to get it to work
Thanks

 

[doofusboy]

You mean something like this?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column > 2 And Target.Column < 10 Then
        Target.Value = "TBD"
    End If
End Sub

 

[Corleone]

You mean something like this?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column > 2 And Target.Column < 10 Then
        Target.Value = "TBD"
    End If
End Sub

This code runs whenever i select a cell
i need something similar to this but just to run when i click on the button i assign it too

thanks for the response btw

 

[doofusboy]

if any cell within that row is selected

The code does exactly what you asked for. A variation of it can certainly be used in a button click event.