I want to create a macro that generates a table via parameters entered into a text box. For example, I would like a simple test box asking the user to input the following parameters and generate a table from those parameters:
  • Number or Columns
  • Number of Rows

I would also like to have this table generate on a template with the same title every time. Essentially, the only changing variables would be the number of rows and columns. If anyone could point me to a resource to help broaden my knowledge with VBA pertaining to this example, I would appreciate it.

Thanks for reading.