To insert new rows into a table using a custom dialog box

[jimmalk]

Hello. My goal is to be able to select any cell in a table , click a button with attached code , and have a dialog box come up offering to insert x-number of new rows after the row of the selected cell. In the dialog box would have user input: a) of the number of new rows to insert (defaulted to 1, maybe with a field with a spin control?), and b) if the new rows should be empty or clones of some of the columns in the original selected cell. I hope I expressed this ok.

In the sample spreadsheet, I would like to be able to (for example) select [E12], and insert down either partial clones of row 12 x-number of times (user input), or x-number of blank rows. Only columns C:I, L:L would be cloned down if clone copying is chosen by the user. I dont have experience in custom dialog boxes. I imagine a good way to pass the contents of a cloned row to the dialog box would be through an array, but I dont know how to set up and pass the array to the dialog box and then return the user input back into an .Insert Shift:=xlShiftDown to execute the insert. Maybe this is a common type of question. I appreciate if anyone has a 'canned' solution they could share. Thanks very much.

[JosephP]

try the attached workbook and let me know :-)

[jimmalk]

Awesome!! Really great Joseph!! It is exactly what I want to do, with only one exception. On the clone control I need to specify which fields are to be cloned. It will vary. Maybe a checklist of all the fields where the "to be cloned field" gets checked off if it is to be cloned? But this is really awesome. I am learning evrything with excel now and forms are still an area that I dont know anything. Thank you so so much. Un abrazo grande!!

[jimmalk]

I see I didnt write clearly in my original post about the cloning being for variable fields, and not strictly fixed (I meant those columns to be examples, but not fixed). I apologize for not being clear, I just noticed that now.

[JosephP]

ok. I need to get a couple hours sleep now but I'll work on it later

[JosephP]

this should get you pretty close even if it's not exactly what you want

[jimmalk]

Absolutely awesome Joseph!!! Not only is it perfect, but the code is so compact. I'm really looking forward to figuring out how it works. I'll only have to adapt it a little bit its so perfect. Really, really cool!!! Thank you so much!!! Un abrazo muy grande amigo!!! (I dont actually speak much Spanish, but I like practicing it) haha Thank you very much Joe. It's really a great help to me Best Wishes..

[jimmalk]

I'm trying to click your rep star, but it doesnt let me because I think I just repped you yesterday. But I'm getting back to this post to rep you again when it lets me. To anyone who ever sees your solution, I'm sure they'll find it really useful!! Thanks so much