So I had this terrific little macro going in my sheet. Whatever someone inserted a new row, it would automatically add a checkbox and a form dropdown to specific columns in that new row, along with linked cells for both:Unfortunately, due to [reasons], I have to start my workbook over using ActiveX dropdowns instead of form control dropdowns. I have changed the relevant line of code to this:![]()
Please Login or Register to view this content.
Now, instead of inserting the combobox in column G of the new row, it inserts the combobox in whatever cell happens to be active. It does pull the appropriate range of dropdown values and it does set the linkedcell to be the right one, but I really need the dropdown itself to go into column G. Why is it not doing that, and how can I fix it?![]()
Please Login or Register to view this content.
Bookmarks