+ Reply to Thread
Results 1 to 4 of 4

Macro assign to ActiveX Combobox

  1. #1
    Registered User
    Join Date
    09-03-2014
    Location
    houston
    MS-Off Ver
    2010
    Posts
    6

    Macro assign to ActiveX Combobox

    I have ActiveX Combobox and PivotTable Record Macro. In Form control combobox, can link both with Assign Macro. How to find the link in ActiveX Combobox? Or idea for VB code. Thanks!

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Macro assign to ActiveX Combobox

    Enter design mode, then right-click the activex control and choose View Code. You can then choose the event you want to trigger your code from the dropdown list at the top right of the code module.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    09-03-2014
    Location
    houston
    MS-Off Ver
    2010
    Posts
    6

    Re: Macro assign to ActiveX Combobox

    How to trigger the Marco code, May you please give me some details or send me a sample? thanks!

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Macro assign to ActiveX Combobox

    When you choose View Code, you should see this by default (the name of the control may be different):
    Please Login or Register  to view this content.
    You can put your code inside that routine or, if you have an existing macro, just add
    Please Login or Register  to view this content.
    inside the routine.

+ 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. ActiveX combobox in spreadsheet re-sizes each time the macro runs
    By jfoerch in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2013, 12:43 PM
  2. [SOLVED] assign macro to activeX combo box
    By Blake 7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2012, 11:19 AM
  3. how to assign a different macro to each*combobox selection in form control....
    By kritigupta in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2012, 03:04 AM
  4. how to assign a different macro to each*combobox selection in form control....
    By kritigupta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2012, 07:51 PM
  5. Populate a activeX combobox from a selection of another combobox
    By ptramel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2009, 06:50 PM

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