Form Contol Button Macro VBA

[jrgregory]

I need a form Button to Move to the relative cell in Column J (relative to the row I'm typing in). So, if I'm typing in any cell in row 25 I need it to move to Cell J25 and type a text when I press the form button. I know how to get the text in. When I record a Macro, it's recording an offset. Any help is most appreciated.

 

[Jeffrey Mahoney]

Do you really need it to move to cell J25? This sample code puts some text in column J of the active row.

Sub AddTextToColJ()
  Dim Sht As Worksheet
  
  Set Sht = ActiveSheet
  Sht.Cells(ActiveCell.Row, "J").Value = "Text from Source"
  
End Sub

 

[jrgregory]

Works like a charm! You're the Hero! Thanks.