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


    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