Using VBA to add a Text box to a page from a userform

[mkeller2876]

Hi all,

New here. I'm looking for some ideas on how to create a macro to pop up a userform with a couple questions to create and text box down the side of the page with numbers. I would like the userform to ask the user what number to start with, what number to end with, and spaces between numbers (line returns) and how many numbers to count by. Like below start with 1 put 3 spaces in and then number 5 and so until the end. I have got as for as the text box placement and size and adding basic line of text. After that I'm struck. I have been googling trying to figure out snippet of it and pieces of the code but run into issues.

Thanks for any help or direction

1



5




10

[Surrogate]

Hi,

can you shape your snippet ?

[wapperdude]

Which part of the process is the problem... 
1) Creating the User form
2) creating code that uses the info to build the text box?

What should happen if the user info manifests into text box too big for the page?  Like maybe it's a mile long?  😵😬