+ Reply to Thread
Results 1 to 2 of 2

RGB Issues

  1. #1
    Registered User
    Join Date
    02-27-2014
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    25

    Wink RGB Issues

    Morning all,
    Thank you in advance.

    I have a bit of code that takes a RGB colour from the text of a cell. (as RequiredColour)
    It will then get the Colour of the pixel under the mouse (as CurrentColour)
    It will then loop until the pixel colour = required colour.

    The bit of code i have doesnt take the RGB colour out of the Pixel however so i convert it into RGB which is fine.

    Please Login or Register  to view this content.
    As part of the code however i want a two userform text boxes to show the CurrentColour and the RequiredColour. As they appear as String without the commas

    Please Login or Register  to view this content.
    Simple!

    However, when it does the above, the BackColor converts and does not equal what i want it to be. I have attached the Watch List if that helps
    WAtch.PNG

    Please can someone either explain and fix the above issue so the textboxes can equal the required colours

  2. #2
    Registered User
    Join Date
    02-27-2014
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: RGB Issues

    ------bump------

+ 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 to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2016, 08:07 AM
  2. [SOLVED] Excel to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 02-11-2016, 07:57 AM
  3. [SOLVED] Several issues at once.....
    By Okii in forum Excel General
    Replies: 6
    Last Post: 02-18-2015, 01:24 PM
  4. Replies: 3
    Last Post: 07-16-2014, 01:50 AM
  5. Data Validation List Issues/Sorting Issues
    By taylorbe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-12-2014, 09:53 AM
  6. [SOLVED] C# VBA DLL issues
    By Temporalis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2006, 11:25 AM
  7. [SOLVED] need help for several issues
    By bandy2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-14-2005, 11:06 PM

Tags for this Thread

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