+ Reply to Thread
Results 1 to 2 of 2

VBA works for Form Combo box but not Active X

  1. #1
    Registered User
    Join Date
    07-22-2019
    Location
    England
    MS-Off Ver
    2011
    Posts
    2

    VBA works for Form Combo box but not Active X

    I am trying to make it so I can use an ActiveX combo box to open hyperlinked files. I have VBA code to do this with the FOrm Combo Box but due to requirements of the interface Im working on I need to use an active X combo box. Can someone fix my code. thanks

    This link shows what I'm trying to do. But when I try use the VBA on an activeX combo box i get type match error 13.
    Drop Down List Hyperlink

    Please Login or Register  to view this content.
    Last edited by Leith Ross; 07-22-2019 at 04:35 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: VBA works for Form Combo box but not Active X

    Hello fayton,

    Welcome to the forum!

    Here is the event code for ComboBox1 located on a worksheet.

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ 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. Dynamic Combo Box: Form control vs active X
    By TheRobsterUK in forum Excel General
    Replies: 2
    Last Post: 12-10-2018, 01:40 PM
  2. [SOLVED] Simple User Form Combo Box code only works when it wants to, It's driving me mad!
    By Rudidw in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-09-2015, 12:37 PM
  3. Code works with Combo Box-Form Control, but not with Combo box - ActiveX Control
    By nangys in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-01-2014, 08:51 AM
  4. [SOLVED] Difference between "Form" & "Active X" Combo Box
    By batchy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2014, 11:18 AM
  5. Active Sheet from Combo Box Selection (User Form)
    By justinep in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 12-24-2013, 03:06 AM
  6. Replies: 1
    Last Post: 12-03-2012, 08:55 AM
  7. Dynamic combo row source - works only if active source worksheet
    By fredpox in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-21-2010, 07:16 AM

Tags for this Thread

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