VBA - Insert Text from Textbox into every nth row

[Versonol]

Hi

I need some help with Vba code to insert the text from the Textbox into every nth row in a specific sheet i.e. Each time the Ok button is pressed, the text from the text box would be inputed into Row1 then Row8 the next time the button is pressed and so on (Sorry for the bad English)

 

[SQUIDD]

Hi

Would need to modify it to suit your textbox value, but basic idea below.

code goes in your command button and "hi" is your textbox value

If Range("A1") > "" Then
    Range("a" & Range("A" & Rows.Count).End(xlUp).Row + 7) = "hi"
Else
    Range("a1") = "hi"
End If

 

[Versonol]

It works! Thanks for the help.

 

[SQUIDD]

Your welcome,