+ 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 Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    24,808

    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

    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 Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    24,808

    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)

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