none
Insert new row on clicking a button using Macro RRS feed

  • Question

  • Hey guys,

    I have a row like 8 columns of data filled with default values. I want to create a button so that whenever a user clicks on the button. It inserts a new row with the same default data. All the columns are also drop down lists. Any help would be much appreciated

    Thanks

    Monday, April 8, 2013 1:30 PM

All replies

  • Take look on this build in form, without code with search and create new line

    

    But if you want to build form by your self you should create collection with unique items and Add them to listboxes.

    You can use part of this article 


    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Monday, April 8, 2013 2:44 PM
    Answerer