Including a ComboBox when inserting a new table row with Macro

  • Hi all,

    I am looking for help with a macro that inserts a new row to a table that includes a combobox in one of the columns. I have created a macro with a CommandButton that carries down formulas and formats from the last row in the table but I do not know how to include the ComboBox. I am using Excel 2013.
    The table is found in columns A thru I in rows 20 thru 27 with the ComboBox in column H

    the following is the code I have so far.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!