Need help creating pop up box that displays information from box to table

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!

Sorry for not being more clear about what I was wanting the box to do. I want to be able to enter a letter into the column textbox and then numbers into the row textboxes. Using the previous layout, it would look like this:

Column: [A]

Rows:[1] to [37]

{Add to Table} {Exit}



When I hit 'Add to Table', I want the information to go to the table and then clear the information from the boxes so that I can enter the next set of information. After multiple entries, the table would look like this:

ColumnA ColumnB ColumnC ColumnD ColumnE
A1 to A37 B1 to B37 D1 to D37 E1 to E37 F7 to F37
H1 to H10 H17 to H37

6StringJazzer mentioned using listboxes or comboboxes. I'm open to the idea, but I want to make sure that it includes all possible options. For example, I would need the columns to go into the double letter alphabet (AA, BB, etc) and the numbers would need to go up to 500 just to be sure that I had more than needed. Please let me know if you need more information. Thanks again for all the help!

Ah, that example is much better. So the column and row ranges are the information that is to be put into the cells. I thought it was somehow telling what cells to use. The example is very helpful.

This will accept any valid cell, from A1 to XFD1048576. It uppercases the column letters.

Thanks that worked exactly as I was picturing in my head!

You had mentioned using the listboxes or comboboxes. Is that still an option for what I'm wanting to do? Or no?

I'm trying to add a line to the code that you gave me, but I'm trying to figure out where it goes. I want to add a row after each time the column get to "E". Mind helping me out again? >.<

It's an option but I don't think it's a very good one. To allow 500 rows, plus all columns with double letters, that's 676 columns--those numbers would make for listboxes that are very unwieldy for the user. I guess you could use two listboxes, one for the first letter and one for the second. But with so many choices I felt it was better to go with textboxes with validation. The validation isn't that difficult. I don't know if you tried giving any invalid specifications but the user will get error messages when that happens.

Originally Posted by ddouget1

I'm trying to add a line to the code that you gave me, but I'm trying to figure out where it goes. I want to add a row after each time the column get to "E". Mind helping me out again? >.<

Every time the row is filled to column E, the next set of values already starts in the next row. I'm not sure what you mean.

It is much more efficient to provide a complete description of what you want to do the first time...This version inserts a line to keep moving your text down.

I also corrected the problem with column letter validation. The logic for string comparisons wasn't correct.