Help Pre-Populating userfrom into unknown textbox

So I would like to pre-populate my userfrom with values that are known, just the location of where those values should go within the userform is dynamic.

I have (40) textboxes (named tbx1 through tbx40) on my userform.

I would like the value that is on Sheet9, Cell K7 to be located within tbx(?) and ? is a number that is Cell J6 value plus 1.

or

Please Login or Register  to view this content.

Any suggestions is greatly appreciated!

Hello clemsoncooz,

Provided that the values in J6 plus one range from 1 to 40 then should work...

Please Login or Register  to view this content.

[Please take the time to mark the thread as solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save