macro to change font color with drop down list

I have a listbox from which to choose font color for editing, linked to another cell. This code points to that linked cell to find the color choice and then specifies the font should be that color. It only works sometimes and I cannot figure out why. I put in the msgBox to track the variable. The message box comes up, but the variable value does not. So clearly the variable is not being set properly. Any ideas?

Please Login or Register  to view this content.

you don't have quotes around red or blue for starters.

Yes, that is true. I was experimenting with that part of the code. It doesn't work with or without the quotes.

I just tested it, it is working for me. maybe post your work book?

Thanks for trying to help with this. I don't know why it worked for you, but not me. I changed the code that specifies the location of the "colorchoice" variable. It works perfectly now. Thanks again.

Please Login or Register  to view this content.