Selecting Sheet based on tab color

[keineko]

Hello,

I'm fairly new to VBA scripts, but I'm trying to make a table of contents page, but depending on the tab color and/or name, I wanted it to display something else. Right now, I have:

Please Login or Register  to view this content.

But what if some of my sheets have different names, like "SAMPLE," and what if I need the "TextToDisplay" command to be TextToDisplay:="='APP" & i & "'!A5" depending on a different sheet color?

Sorry, I hope my question makes sense.

Thanks very much for any help.

[mikeTRON]

So you can use if statments and the colorindex property.

The following code will loop through all of the tabs and display the color#

Please Login or Register  to view this content.

[keineko]

Hi, and thanks for the input. After running the macro, I obtained the color index code and amended my original syntax to:

Please Login or Register  to view this content.

However, the table of contents still displays the cell value of A2 regardless of the value I insert in ColorIndex. Any additional input is very much appreciated!

[keineko]

Ah, I found it out!

Please Login or Register  to view this content.

Yay.