Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Pallette
I have just discovered that the color numbers for the cells and the color
numbers for BackColor for labels and text boxes are different numbers. I have a UserForm and I want the users of the spreadsheet to click on names in a list box and turn the color of a text box on the UserForm the same color as a cell on the spreadsheet that belongs to them, but the color numbers are different. Any ideas how to correlate these two numbering systems? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Pallette
This worked for me:
Private Sub CommandButton1_Click() TextBox1.BackColor = ActiveCell.Interior.Color End Sub -- Regards, Tom Ogilvy "Steve" wrote in message ... I have just discovered that the color numbers for the cells and the color numbers for BackColor for labels and text boxes are different numbers. I have a UserForm and I want the users of the spreadsheet to click on names in a list box and turn the color of a text box on the UserForm the same color as a cell on the spreadsheet that belongs to them, but the color numbers are different. Any ideas how to correlate these two numbering systems? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color Pallette Issues | Excel Discussion (Misc queries) | |||
Color Pallette and Font | Excel Discussion (Misc queries) | |||
Color pallette changed spontaneously, what the...? | Excel Discussion (Misc queries) | |||
Changing Excel's Color Pallette | Excel Discussion (Misc queries) | |||
Changing Color Pallette ? | Excel Discussion (Misc queries) |