JaredMcCullough
Well-known Member
- Joined
- Aug 1, 2011
- Messages
- 516
I was looking to utilize a Macro to create a portion of a template for me. I was hoping to maybe use a Userform instead of an Inputbox style as it will provide more friendly for the user creating the template. My goal was to use Textbox inputs in a userform to generate a header row then generate a number of rows after. So an example would be "Textbox1" would generate a row after row 15 (thus row 16) and populate column A of that Row with the "Name" typed into the textbox. Then on the Userform right beside "Textbox1" will be "Textbox2" which promotes for "Number of Questions". The user inputs a number in this box (ex. 6) and when the hit the command button for the userform it do the following: Generate a header row after row 15 and put the name in cell A of that row, then generate 6 rows below that as that is what the user input.