UserForm Code

[Jamm_027]

I need the amount entered in Textbox1 of Userform1 to be placed in a cell in column "Y".

The issue for me is that the row for the cell in column "Y" will be dependent on what the active cell is when the macro runs.

I think I am close. Here is what I got so far:

Private Sub CommandButton1_Click()

Dim i As Long
i = ActiveCell.Row

Sheets("Exception Form").Range("Y" i).Value = UserForm1.TextBox1.Value

Unload Me

End Sub

thanks, jamm

 

[VoG]

Very close

Sheets("Exception Form").Range("Y" & i).Value = UserForm1.TextBox1.Value