TextBox Naming & Value Input

I have userform (frmLine) with six TextBoxes named txtPrice, txtPrice1, txtPrice2 etc.
The userform has a TextBox (txtLines) which shows a line number.
The value to be inserted into the last five TextBoxes is based on the first (txtPrice).
Instead of using the following code:

Please Login or Register  to view this content.

I wish to use code similar to the following:

Please Login or Register  to view this content.

But this is not working! What modification can I make to get it working”
Thanks Sandy

Bakerman2 I am trying to simplify some coding to enter data, have a look at the attached which shows the beginning of the form (a work in progress).
I was using Select Case but there were 6 sets of code. With Mikes code there is only one set.

Mike thanks, with a slight modification it worked.

Please Login or Register  to view this content.

Cheers Sandy