Excel color palette

[zookeepertx]

Hello all,
It used to be that you could right-click to show the Cell Color palette to change a cell's color and then grab the palette and drag the whole box down so it showed all the time. You could do the same thing with the Font Color palette. Now, you have to right-click and select directly from the displayed palette instead of having the palette already there to just choose from.
I have several worksheets that I have to go through and evaluate a large number of cells, one at a time, then decide what color to make the cell. Because there are so many cells to evaluate, it's kind of a (small) pain to have to ask for the palette every single time I need to change a cell's color. Is there a way to get that little box with the color palette to show all the time like you used to be able to do?
Conditional Formatting won't work because there is such a variance of reasons why a cell needs to be a particular color.

This little box is what I'm talking about.

(I hope this question is clear. I tend to "over-describe" things and confuse people when I'm typing/writing)

Thanks!

Jenny

 

[MARK858]

And, on the subject of color mixing... What is Green doing in there anyway? The color wheel is based on Red, YELLOW and Blue. Green is between yellow and blue and is not a primary color. You have to mix those 3 - R, Y and B - to get whatever other colors you need, although white needs to be available to turn red into pink.

Primary Colors Are Red, Yellow and Blue, Right? Not Exactly

Primary colors are the blocks from which all other colors are built. But there's a lot more to know about them than the basic red, yellow and blue we learned about in kindergarten.

science.howstuffworks.com

 

[zookeepertx]

Primary Colors Are Red, Yellow and Blue, Right? Not Exactly

Primary colors are the blocks from which all other colors are built. But there's a lot more to know about them than the basic red, yellow and blue we learned about in kindergarten.

science.howstuffworks.com

NOOOO!!!! My whole life is a lie!!

 

[zookeepertx]

Another color value question, Mark.

The Hex values are various mixes of numbers AND letters. How do those combine to mean anything? I mean, the numbers make sense: The higher the number, presumably the more of that color is involved. But what do the letters mean?

 

[MARK858]

What Is the Hex Code? Everything You Need to Know

How do you identify a color? Find out how a short string of six characters can tell you all you need to know.

www.makeuseof.com

hex number/letter	Decimal number
0	0
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
A	10
B	11
C	12
D	13
E	14
F	15

 

[zookeepertx]

vbModeless will keep it open until you close it.
I made one to try it with only 10 colors and it works like a charm.
As a matter of fact, I added it to the QAT Userform

I DID IT!! I figured it out!! I made a userform (following your suggestion in a previous post) that I can call up with a macro, and it STAYS OPEN as long as I need it to! I'm doing a happy dance over here!

Nothing I try to do ever works without someone fixing it for me. WOOHOO!

I did have a little trouble with the Hex code when coloring the labels in the userform because of the characters being in a different order, but once Google helped me figure that out, it all came together.
I used your code to make the macro to call up the Userform:

Sub Show_Me()
    Color_Palette.Show vbModeless
End Sub

And then created all the colors of the labels. The coding for putting those colors into the cells is a bit long though. Is there any way to clean it up? And I assume there's no way to incorporate the Userform's coding in the macro module, right? Just in case someone else wants to use this, I'd hate if I gave them the macro module and forgot to give them the Userform module.

Private Sub Label1_Click()
ActiveSheet.Range(Selection.Address).Interior.Color = Me.Controls("Label1").BackColor
End Sub
Private Sub Label2_Click()
ActiveSheet.Range(Selection.Address).Interior.Color = Me.Controls("Label2").BackColor
End Sub
Private Sub Label3_Click()
ActiveSheet.Range(Selection.Address).Interior.Color = Me.Controls("Label3").BackColor
End Sub
Private Sub Label4_Click()
ActiveSheet.Range(Selection.Address).Interior.Color = Me.Controls("Label4").BackColor
End Sub
Private Sub Label5_Click()
ActiveSheet.Range(Selection.Address).Interior.Color = Me.Controls("Label5").BackColor
End Sub
Private Sub Label6_Click()
ActiveSheet.Range(Selection.Address).Interior.Color = Me.Controls("Label6").BackColor
End Sub
Private Sub Label7_Click()
ActiveSheet.Range(Selection.Address).Interior.Color = Me.Controls("Label7").BackColor
End Sub
Private Sub Label8_Click()
ActiveSheet.Range(Selection.Address).Interior.Color = Me.Controls("Label8").BackColor
End Sub

(I didn't include the code for ALL the labels; it seemed redundant, LOL!)

Also, I created it all in a dummy workbook that I used to play with but want to have it all available in my Personal workbook. Do I have to do anything special to do that or can I just move the macro and the Userform into the Personal workbook in the project window. And do I have to change any of the coding? I only ask because I don't really get what Private Sub means. I googled it and only got more confused.

 

[zookeepertx]

What Is the Hex Code? Everything You Need to Know

How do you identify a color? Find out how a short string of six characters can tell you all you need to know.

www.makeuseof.com

Dang, you're good!
Thanks for the info!

It's complicated but understandable.

Jenny

 

[MARK858]

Dang, you're good!

Not really just know from the past what is available online and where to find it again.
Happy it helped

 

[zookeepertx]

Not really just know from the past what is available online and where to find it again.
Happy it helped

I know where to find a bunch of stuff, but since I've never needed to be concerned about Hex, I'd have had NO clue whatsoever where to even start.
(Mostly, I come here to find out things. )

 

[Dan_W]

Hello. I'm so very sorry for taking so long to get back to you. I've been in the middle of moving but hopefully will start to settle down this weekend.

 

[Dan_W]

NOOOO!!!! My whole life is a lie!!

Honestly... I still haven't recovered from the whole 'Pluto is not a planet's fiasco... and now this..?!

On a slightly related noted, did you see the post in the Articles section re: the Javascript MixBox.js colour library? (Link) it looks amazing. I'm determined to get ChatGPT to convert it into VBA for me (which as little hand holding or corrections by me as possible)