+ Reply to Thread
Results 1 to 3 of 3

assign macro to activeX combo box

  1. #1
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,373

    assign macro to activeX combo box

    Hi - I would like to assign the macro below to an activeX combo box.

    I am right clicking, view code and inserting the macro code between Private Sub ComboBox1_Change() and End Sub, however, to no avail. what am i doing wrong please!

    Please Login or Register  to view this content.
    Last edited by Cutter; 09-05-2012 at 05:35 PM. Reason: Replaced QUOTE tags with CODE tags
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,180

    Re: assign macro to activeX combo box

    Your event code should look like,

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,373

    Re: assign macro to activeX combo box

    thanks andy - thought so. this isnt the problem then!!! cheers mate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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