How to change a word in a Keyword?

[prabha_friend]

For Example:
Cell.Interior.Color = "vb"&Cell.Offset(0,1).value

The value is a text "Green"

The expected keyword is vbGreen. Possible?

I know I have to post it in an excel section of this forum as the example is an excel code. I believe the purpose decides the right section

 

[vbaInet]

It's either you write a bunch of SELECT..CASE statements to resolve the value or you create a table for it.

 

[prabha_friend]

Can we conclude that we cannot change a word into a
Keyword?

 

[vbaInet]

We can certainly conclude that.