+ Reply to Thread
Results 1 to 6 of 6

ActiveX Combo Drop Down Box Questions

  1. #1
    Registered User
    Join Date
    04-26-2018
    Location
    Huber Heights OH
    MS-Off Ver
    2010
    Posts
    7

    ActiveX Combo Drop Down Box Questions

    Hello All!

    I am using Active X drop down box list because I wanted the option to adjust text size etc. My question is there a way to make each text option in the drop down a different color? I am using more than 1 of these drop downs. I have attached the file. It is a shop clock in/out simple sheet.

    Thanks,
    Kevin
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: ActiveX Combo Drop Down Box Questions

    Hi

    Code like the following would be one way

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    04-26-2018
    Location
    Huber Heights OH
    MS-Off Ver
    2010
    Posts
    7

    Re: ActiveX Combo Drop Down Box Questions

    Richard,

    Will this work ok since I am using the same drop down list for 14 people? All I did was just to copy and paste the combo/drop down list for all.

    Thanks,
    Kevin

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: ActiveX Combo Drop Down Box Questions

    It doesn't appear that the code is copied along with the combobox when you copy and paste it.

    You would have to go into the code event of every combobox and add it

  5. #5
    Registered User
    Join Date
    04-26-2018
    Location
    Huber Heights OH
    MS-Off Ver
    2010
    Posts
    7

    Re: ActiveX Combo Drop Down Box Questions

    Got it! Thank You Very Much!

  6. #6
    Registered User
    Join Date
    04-26-2018
    Location
    Huber Heights OH
    MS-Off Ver
    2010
    Posts
    7

    Re: ActiveX Combo Drop Down Box Questions

    Richard,

    I have another question!

    Could this excel sheet be converted to a webpage even though it has activex and vb programming?

    Thanks,
    Kevin

+ 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. Combo-box (activex) copy paste value into combo-box
    By exceliousss in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2018, 08:23 AM
  2. ActiveX Combo Box Clear
    By kangsongwu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2014, 03:40 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. Replies: 8
    Last Post: 12-26-2013, 02:23 PM
  5. ActiveX combo-box value depends on other combo-box value
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 09-27-2013, 05:24 PM
  6. Population a Combo Box ActiveX
    By ABabeNChrist in forum Word Formatting & General
    Replies: 1
    Last Post: 09-10-2009, 03:49 PM
  7. Modifying Drop-Down Text in an ActiveX Combo Box
    By akexcel in forum Excel General
    Replies: 3
    Last Post: 10-23-2006, 01:13 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