VBA, Store value in another sheet

[Batteredburrito]

Hi, I have the current VBA code to change the names within a sheet.

Private Sub ChangeNames_Click()

Dim Payer1 As String
Dim Payer2 As String

Payer1 = InputBox("Please enter a payers first name")
Payer2 = InputBox("Please enter a payers first name")

Range("a7").Value = Payer1
Range("a8").Value = Payer2

End Sub

Its currently set to store the values in cells A7 and A8 of the current sheet. I now need to offload this to a cells B2 and B3 to sheet 6 named Essential Info.

Im not sure how to properly reference the sheet and cells in the Range set. Any advice?

 

[Scott T]

Try

Private Sub ChangeNames_Click()
Dim Payer1 As String
Dim Payer2 As String
Payer1 = InputBox("Please enter a payers first name")
Payer2 = InputBox("Please enter a payers first name")
Sheets("Essential Info").Range("B2").Value = Payer1
Sheets("Essential Info").Range("B3").Value = Payer2
End Sub

 

[Batteredburrito]

This does exactly as needed. Thank you!