+ Reply to Thread
Results 1 to 1 of 1

Create userform that allows user to pick a color, then have macro reference the color pick

  1. #1
    Registered User
    Join Date
    12-12-2012
    Location
    Exceland
    MS-Off Ver
    Excel 2010
    Posts
    24

    Create userform that allows user to pick a color, then have macro reference the color pick

    Hi,

    I know how to create userforms, but am having a lot of trouble figuring out how to have users somehow pick a color on a userform (either by entering an RGB number string in a textbox or some other method), and then have a macro reference that color choice.

    In addition, ideally I'd like the user to be able to pick several sets of colors which will be referenced by the macro to do different things.

    Any ideas? I'm primarily going to put the code in powerpoint but imagine the language is similar for excel.

    Thank you!

  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,258

    Re: Create userform that allows user to pick a color, then have macro reference the color

    Hello submariner18,

    The attached workbook should help you. It allows you to create and save custom colors. These are saved on the local machine. Because they are saved to the registry using standard VBA Interaction methods, they can be accessed by another VBA projects you create.
    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. Excel color-pick eye dropper
    By globalpontoon in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-12-2019, 11:59 AM
  2. Replies: 2
    Last Post: 10-21-2011, 07:22 AM
  3. formula to pick cell color
    By gurpreet0802 in forum Excel General
    Replies: 1
    Last Post: 01-20-2009, 06:34 AM
  4. [SOLVED] Start Macro after user selects a choice from a pick list
    By Mathew in forum Excel General
    Replies: 2
    Last Post: 08-17-2006, 10:30 AM
  5. [SOLVED] I need to use a formula to pick up a value by the font color?
    By Harshad in forum Excel General
    Replies: 1
    Last Post: 01-27-2006, 09:10 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