I'm trying to create a box in excel 2010 that when it pops up it gives you 3 textboxes to enter information. How I have it laid out in my head is like this (the 'Add to Table' & 'Exit' are buttons that will be in the box:


Column: [TextBox1]

Rows:[TexBox2] to [TextBox3]

{Add to Table} {Exit}


After information has been added to the table, I want the box to be cleared so that I can enter in the next set of numbers. I also need the table to get larger as each set of numbers is added because sometimes there will be more rows than other times. I don't want the table more than 5 columns wide, so after I enter my 5th set of numbers, I want it to move to the next row and start over in the 1st column. For example:

ColumnA ColumnB ColumnC ColumnD ColumnE
1st set 2nd set 3rd set 4th set 5th set
6th set 7th set




I appreciate any help that can be offered for this. Thanks!