Copy ActiveX combo box along with VBA codes (Change, Got focus, keydown etc) RRS feed

  • Question

  • I have a requirement to build a macro which have to copy the combo boxes (25 Activex combo boxes).These combo boxes have vba codes for got focus, change, keydown event. 

    Is it possible to copy the combo box along with necessary codes?

    Monday, April 6, 2015 4:56 AM

All replies

  • The easiest way would be to copy the entire sheet. This will include all ActiveX controls and the associated code. You can then delete content that you don't need from the copy, if necessary.

    Regards, Hans Vogelaar (

    Monday, April 6, 2015 8:58 AM
  • Thanks for your reply Hans Vogelaar.

    I need to have those info added in single sheet itself.

    My requirement is as follows:

    1)Multiple drop down boxes are there (Student Information Details were there).

    2) When Add Student Button is clicked then All the above drop down boxes related to student information has to be added.(More than 25 dropdowns were there for each student).

    3) When delete student button is clicked then info about that particular student has to be deleted.

    These info has to be in one sheet. All dropdowns were autosearch type ahead using List fill range and Dynamic named list.

    Monday, April 6, 2015 12:58 PM