Consulting

Results 1 to 5 of 5

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

  1. #1

    VBA/Macro to insert rows based on drop downlist selection

    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
    My apologies


    The following site have the same question added:


    1. https://www.myonlinetraininghub.com/...lection#p17348
    2. https://chandoo.org/forum/threads/vb...ownlist.45283/
    3. https://www.ozgrid.com/forum/index.p...ist-selection/
    4. https://www.excelguru.ca/forums/showthread.php?10920-VBA-Macro-to-insert-rows-based-on-drop-downlist-selection
    5. https://www.mrexcel.com/board/thread.../#post-5585077


    Hope thats all the sites.

  3. #3
    VBAX Expert
    Joined
    Apr 2005
    Posts
    854
    Location
    Re: Hope thats all the sites.
    Do you want us to go and check all these sites to see if someone has used their hard to get free time to help you and then see if there might be a site that you forgot?


  4. #4
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,097
    Yes, this is a very interesting question.

  5. #5
    Could one of the mods kindly remove this thread?

Posting Permissions

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