Results 1 to 5 of 5

Create drop down menu using ActiveX comboBox

Threaded View

  1. #1
    Registered User
    Join Date
    02-14-2017
    Location
    Asheville, NC
    MS-Off Ver
    Excel 2013
    Posts
    4

    Create drop down menu using ActiveX comboBox

    Hello, I am new here, please be kind! I am trying to create a drop down menu that will fire different macros based on the selection from the ComboBox. I have been successful using form control ComboBox, but for flexibility I'd like to do this with an ActiveX ComboBox. I've attached (I hope!) a sample file. The macros work fine independently, but I get a "Object doesn't support this property or method" error when the "change" macro hits the "case" syntax... Any and all help would be greatly appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Tab into combobox with autocomplete drop down menu
    By jparry85 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2016, 04:54 PM
  2. [SOLVED] Dynamic ComboBox (Drop down) menu in a VBA UserForm
    By igormigor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-17-2015, 05:07 AM
  3. [SOLVED] fill listbox (ActiveX) based combobox (ActiveX)
    By elsg in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-31-2014, 11:25 AM
  4. How to create a drop down menu/box
    By Onesock in forum Excel General
    Replies: 4
    Last Post: 10-27-2012, 07:06 AM
  5. [SOLVED] I cant work out how to create a drop down menu that relates to another drop down menu
    By louise2613 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-18-2012, 01:49 PM
  6. [SOLVED] Drop down menu-Can I create a drop down menu
    By murph in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-21-2006, 10:25 PM
  7. Ho Do I create drop down menu?
    By Lu Roe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2005, 10:06 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