Vba to auto populate text in another adjacent cell.

[MoonLove]

Hi Team,

I am requesting for macro that will do the following:

- Automatically populating username called "MoonLove" in every row of column F, when a row in column E is filled with any text or value.

Alex Blakenburg​

Thanks for your continuous support.

 

[rakesh seebaruth]

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 5 Then
        If Target.Value <> "" Then
            Target.Offset(0, 1).Value = "MoonLove"
        End If
    End If
End Sub

 

[MoonLove]

Thank you rakesh seebaruth. It has worked.