Colourful Language

Mike54 · May 23rd, 2002, 01:57 AM

Good Morning, can you please tell me if it's possible to change/edit the "names" of the colours in the flood fill drop down box. For example could I change the colour name Sky Blue to vacation?

Many thanks

Mike 54 (UK)

dk · May 23rd, 2002, 03:08 AM

Hi Mike,

I don't think that it's possible to change the tooltip text either manually or through VBA. I tried the following code to try and gain access to the 'choose colour' grid and I couldn't do it. The grid is a single control whose properties (e.g. the tooltip text) would have been set when Excel was being designed.

Sub GetFloodBar()
Dim ComBar As CommandBar
Dim but As CommandBarControl
Set ComBar = Excel.CommandBars("Fill Color")

For Each but In ComBar.Controls
MsgBox "Caption = " & but.Caption & vbCrLf & _
"Type = " & but.Type & vbCrLf & _
"Tooltip = " & but.TooltipText
Next

End Sub

Anyway, all is not lost. Have you considered creating a userform with coloured labels on it? You could easily incorporate all the functionality of the standard fill colour toolbar plus anything else you want.

Let me know if you'd like an example workbook,

Dan

Mike54 · May 23rd, 2002, 01:53 PM

Hi Dan
Thanks for replying to my question on Mr Excel, I’m not quite sure what you mean by coloured labels so if you would be kind enough to send me an example that would great. Thanks for trying to solve the problem, you see about 25 people use the spreadsheet and I am trying to get them all to use the same colours, I think I may just change the irrelevant colours to white, cheers
Mike54

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 01:57 AM	#1
Mike54 Board Regular Join Date: Apr 2002 Location: London, England. Posts: 179	Good Morning, can you please tell me if it's possible to change/edit the "names" of the colours in the flood fill drop down box. For example could I change the colour name Sky Blue to vacation? Many thanks Mike 54 (UK)

May 23rd, 2002, 03:08 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Hi Mike, I don't think that it's possible to change the tooltip text either manually or through VBA. I tried the following code to try and gain access to the 'choose colour' grid and I couldn't do it. The grid is a single control whose properties (e.g. the tooltip text) would have been set when Excel was being designed. Sub GetFloodBar() Dim ComBar As CommandBar Dim but As CommandBarControl Set ComBar = Excel.CommandBars("Fill Color") For Each but In ComBar.Controls MsgBox "Caption = " & but.Caption & vbCrLf & _ "Type = " & but.Type & vbCrLf & _ "Tooltip = " & but.TooltipText Next End Sub Anyway, all is not lost. Have you considered creating a userform with coloured labels on it? You could easily incorporate all the functionality of the standard fill colour toolbar plus anything else you want. Let me know if you'd like an example workbook, Dan

May 23rd, 2002, 01:53 PM	#3
Mike54 Board Regular Join Date: Apr 2002 Location: London, England. Posts: 179	Hi Dan Thanks for replying to my question on Mr Excel, I’m not quite sure what you mean by coloured labels so if you would be kind enough to send me an example that would great. Thanks for trying to solve the problem, you see about 25 people use the spreadsheet and I am trying to get them all to use the same colours, I think I may just change the irrelevant colours to white, cheers Mike54