+ Reply to Thread
Results 1 to 5 of 5

Macro code to change the ActiveX Control Object Properties

  1. #1
    Registered User
    Join Date
    07-31-2012
    Location
    Buffalo, United States
    MS-Off Ver
    MS Office 2007, 2010, 2013
    Posts
    59

    Macro code to change the ActiveX Control Object Properties

    I am working on a project and it has more than 40 tab sheets. I need to add the Combo Box into each sheets and change the properties to fit with the need. Is there anyone know what code should I use in macro so that all Combo Box will have the same properties in just a click? Also, what about the code for other object such as Checkbox and Toggle function if I want to change the properties too?

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    What are you going you click to populate the comboboxes?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    07-31-2012
    Location
    Buffalo, United States
    MS-Off Ver
    MS Office 2007, 2010, 2013
    Posts
    59

    Re: Macro code to change the ActiveX Control Object Properties

    I can populate the combobox by drag and fill-in, but I want a macro to set the properties of each combobox such as BackStyle, DropButtonStyle, ShowDropButtonWhen and etc.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    What will you be clicking to trigger the code to do that?

  5. #5
    Registered User
    Join Date
    07-31-2012
    Location
    Buffalo, United States
    MS-Off Ver
    MS Office 2007, 2010, 2013
    Posts
    59

    Re: Macro code to change the ActiveX Control Object Properties

    I will run the code directly from Macros under Developer tab because I need to edit those 40+ sheets to make sure all combobox will have the same properties or else I need to do it manually and check each of them one by one.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Index of ActiveX control properties.
    By JO505 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2013, 06:00 PM
  2. Accessing a grouped ActiveX control's properties using VBA
    By deadlyduck in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-28-2010, 05:02 AM
  3. ActiveX control can't create object
    By rkjudy in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 08-04-2009, 12:08 PM
  4. [SOLVED] GetObject Error 429 - ActiveX control cannot create object
    By EAB1977 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2006, 09:40 AM
  5. [SOLVED] How do I change activex control properties from a macro
    By Billums in forum Excel General
    Replies: 2
    Last Post: 01-19-2006, 09:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1