+ Reply to Thread
Results 1 to 4 of 4

Button to Insert new Line with Group Box.

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Button to Insert new Line with Group Box.

    Hi, please see my sample. Basically, i wanted a button to "Copy and Paste" the line above. However, i have 3 option box in every row. Row 1 is my header, hence my first line is Row 2. My option box in Row 2 is link to A2, i wanted a button in which when i press will create the exact same option box but link to the row in which it was created. I wonder if its possible. If option box is not possible. Could it be done by using Check Box instead?

    PS, if option box is possible. Could anyone teach me how to make the Group Box invisible?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,651

    Re: Button to Insert new Line with Group Box.

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Re: Button to Insert new Line with Group Box.

    Hey, thanks. It Work! anyway, how do i amend the code in such a way that the S/N in Column B will +1 by itself?

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,651

    Re: Button to Insert new Line with Group Box.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Code that will find and group data together within multiple columns, insert line breaks __
    By onelineatatime in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2015, 06:10 AM
  2. Hit Tab button to insert new line and preserve previous lines formulas
    By eighch in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2014, 09:14 PM
  3. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  4. [SOLVED] VBA for insert total line after one group of record
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2012, 07:18 AM
  5. Add a button to insert new line....
    By DMA-Pacific in forum Excel General
    Replies: 4
    Last Post: 05-13-2012, 02:06 PM
  6. Customised ribbon - displaying a group based on pressing a button in another group
    By micklloyd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-15-2012, 03:55 PM
  7. Macro to sort data, insert a line after each group & then total?
    By karinmpfa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2006, 08:15 PM

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