I have a dropdown list in a sheet from which the user will select a color (the 7 constants) red, cyan...
In my code I wanted to simply put "vb" before it something like:
xcolor = "vb" & user-selected-color
cells(x,y).interior.color = xcolor
But it fails to produce the color. Any ideas? Is...