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,

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,