I forgot to add the code I am using so far

R = 17 'or whatever desired row variable
Sheets(2).Cells(R, 6).Value = TextBox1.Text
seasonname4.Hide


Thanks in advance

Greg