+ Reply to Thread
Results 1 to 11 of 11

How to create a ActiveX dropdown list

  1. #1
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    How to create a ActiveX dropdown list

    hey. being working on this solution for some hours now?
    would anyone how how to use VBA code to get this list working..

    please see attached sheet

    PS it needs to be activex element.

    thx for your help.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    Re: How to create a ActiveX dropdown list

    I guess it was a impossible function!

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,904

    Re: How to create a ActiveX dropdown list

    @ QuantEdge

    Please remember this site relies on volunteers who often are in different timezones so a reaction like that after only 2 hours is a bit ...

    Put this in ThisWorkbook.

    Please Login or Register  to view this content.
    and this in Sheet1 module.

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: How to create a ActiveX dropdown list

    Or:

    Please Login or Register  to view this content.
    To install as cboQ
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  5. #5
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    Re: How to create a ActiveX dropdown list

    xladept , when do I add that code to?

    PS bakerman2 ur code does works! I guess still too complex,

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: How to create a ActiveX dropdown list

    Hi Quantedge,

    Just run it once from a standard module

  7. #7
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    Re: How to create a ActiveX dropdown list

    ok I will try it...

  8. #8
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    Re: How to create a ActiveX dropdown list

    sorry I keep tried that does work!!!

    I have attached my sheet if you could nicely add it...
    Attached Files Attached Files

  9. #9
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: How to create a ActiveX dropdown list

    Well, I ran it - all I did was delete the old one and run the program.
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    Re: How to create a ActiveX dropdown list

    thx xladept, that is amazing save a thousand clicks (* to be given).

  11. #11
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: How to create a ActiveX dropdown list

    You're welcome

+ 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] Detect click on dropdown arrow in an activex dropdown box
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2017, 08:23 AM
  2. [SOLVED] Create an Excel Drop Down list with Search Suggestions ( Serachable Dropdown list )
    By PMH2384 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-11-2016, 12:03 AM
  3. Create dropdown list in Excel that will only list unique entries
    By MissAudrey in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-22-2015, 04:56 PM
  4. [SOLVED] Autocomplete dropdown list, NOT data validation or ActiveX
    By Phillips Contracting in forum Excel General
    Replies: 7
    Last Post: 03-24-2014, 02:31 PM
  5. [SOLVED] Is it possible to create a dropdown list with VBA?
    By construct in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-06-2012, 02:55 PM
  6. UDF to create a dropdown list?
    By jammie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2010, 08:33 AM
  7. Replies: 10
    Last Post: 03-19-2007, 11:30 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