2 combobox click macros are interfering with each other

  • Hi,

    I have created 2 combobox's; 1 for a 'charges' table and the other for a 'credits' table. the list in the combobox's is the same - 1 to 10. When I select the number in the list, the corresponding number of rows in the table unhides. Both work, however, when I select one combobox it resets the other to open all 10 rows in the table and vice versa. How do I get each combobox to run independantly and retain the rows when the other table is changed? Please see below code;

  • Are both the tables on the same sheet? If so then that might be the issue because the macro is not referring to a table. It is just looking at cells/ rows

Participate now!

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