Use a userform to Insert a PIN number in a cell

[nanogr]

I'm trying to use a VB so when an user activate any cell in column H an userform will show and ask for a password. As you can see from the attachment, right now my code only can insert such password in a ''fixed'' sheet range in column G.

What I would like to do is for the code to ''understand'' that if I activate a cell (and hence the userform) in column H let say (2,8) the input value in the textbox should be introduced into a cell in G lets say (2,7) and so on for any activated cell. i.e. I need for every cell that ask for a Pin to act independently but to use the same userform

[6StringJazzer]

Let's try this

Sub Aceptar_Click()
   Sheet1.Cells(ActiveCell.Row, 7) = TextBox1.Value ' modified
   Unload UserForm1
End Sub

[nanogr]

Great, Thanks a lot man.... life saver!!