Microsoft Office Spreadsheet 10 in userform

[depcdivr]

I am getting frustrated.

I am trying to color code some cells in a Microsoft Office Spreadsheet 10 that is contained within a userform. For some reason my colors were not coming out right. I would use the hex color "FF0000" and expecting a shade of red but getting a shade of blue. I quickly realized that I needed to reverse the order of the colors.

Why does the userform use BGR for hex colors when the rest of the world used RGB?

I am also trying to change the color of the font in the individual cells but can not seem to find the correct code to do so? any suggestions?

 

[depcdivr]

I just figured out the font color.

I used

With Me.records.Cells(y, 2)
                .Interior.Color = "000000"
                .Font.Color = "0000ff"
            End With

 

[shg]

RGB in Windows is always encoded like that. In the Immediate window, enter

? hex(rgb(1,2,3))

 

[depcdivr]

I guess that I am just used to programming HTML which is opposite of Windows. Just another thing in this world to mess with my mind.