Changing Tab Colors Via Code (Type Mismatch)

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?

.Tab.Color worked for me.
This syntax should work where UserColor is the selected color form JW's color picker.

Please Login or Register  to view this content.