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.
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
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
Bookmarks