Results 1 to 8 of 8

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

Threaded View

  1. #1
    Forum Contributor jimmalk's Avatar
    Join Date
    08-31-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    113

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

    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.
    Attached Files Attached Files
    Last edited by jimmalk; 10-10-2012 at 04:19 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1