Results 1 to 3 of 3

Thread: VBA/Macro to insert rows based on drop downlist selection

  1. #1
    Neophyte Jet Fusion's Avatar
    Join Date
    Nov 2020
    Posts
    2
    Articles
    0
    Excel Version
    MS Office 365

    VBA/Macro to insert rows based on drop downlist selection



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi
    I'm not sure how or get this to work.
    I would like to add 3 rows based on a selection from a drop down list or would it be better to use a macro to ask which selection/name and then to insert 3 rows.
    Once the rows have been inserted the firs row should be the Name that was selcted in bold and a border around the 3 rows everytime it get inserted and the the two of the rows should have info based on the name that was selected from the drop down list.
    There will be a list of different selections so would it be better to make a data sheet and then the info can be autofilled to the specific rows.
    Also everytime you make a selection the 3 rows that get added will have to continue from the last row that was added. So every 3rd row will have a dropdown list.
    I have attached a file
    Thanks in advance
    JetTest 1 VBA.xls

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,890
    Articles
    0
    Excel Version
    365
    cross posted without links:

    VBA/Macro to insert rows based on drop downlist | Chandoo.org Excel Forums - Become Awesome in Excel
    https://chandoo.org/forum/threads/vb...ownlist.45283/
    VBA/Macro to insert rows based on drop downlist selection
    http://www.vbaexpress.com/forum/show...list-selection

    Jet Fusion, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

  3. #3

Posting Permissions

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