VBA Set Color Text Variable based on color entry in a cell?

Hello, I keep getting errors when trying to set the text color based on a variable. I am sure I am doing something wrong that is fairly simple.

I have a cell that contains the text "vbRed" or "RGB(255,0,0)". I have the following code:

Please Login or Register  to view this content.

The getadminvarvalue gets the data from the cell it finds (again text is entered "vbRed" or "RGB(255,0,0)"), so that parts works correctly. Now the problem occurs when I try to apply the following code:

Please Login or Register  to view this content.

If I use the following code it works, but I cannot figure out how to get it work using a variable.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

both work.

I appreciate your help and insight!

I believe the problem is arising from you trying to set the color to a string variable - the color must be set to either an RGB value (a long type variable), or a vbconstant (e.g. vbred).
The easiest way to get around this would be to change the type of cuTextColor to long, and do something like this

Please Login or Register  to view this content.

Or in your case, if you want to set the variable based on the text in a cell, you could use

Please Login or Register  to view this content.

Except this uses cell "A1" and you would need to change that to your target cell

Thanks. I will give it a try and let you know how it goes!