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,