Posts by Eoliver777


    I needed a macro because the worksheet is protected and will be used by others as a form that may require more lines to be added as needed.


    I need the combobox because a validation table may not always have the latest information and I would like them to be able to write in the correct information if it's not there.


    Good news is I have been able to work through the problem, including having to unlock the worksheet and locking it back up when row is inserted. Other complications that arose were having to clear out the copied data from the row it was copied from.


    If anyone is interested in the details of how this was done, let me know and I will post.

    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.


    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.