Hello all,
I am writing a bit of code for a workbook that is tracking individuals working in groups. I have created a UserForm to add new individuals. On this form I want them to be able to put in their name, their status and to choose a tab color. I found a color picking dialog created by John Walkenbach which returns the color picked as MSACCESS color numbers. This is find for setting back-colors of buttons and such but is not working when I try and apply it to the tab color. I have tried to use .Tab.Color, and .Tab.ColorIndex. However neither have worked. I am sure it is due to the format of the color reference. Is there a way to convert the color reference from MSACCESS format to the 56 color index values?