View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] andrewsacher@gmail.com is offline
external usenet poster
 
Posts: 3
Default evaluation a variable in an expression

Hi,
Is there any way for me to evaluate a string variable as if it were
code. For example, say I have an input string=".Font.ColorIndex = 4".
Is there anyway for me to get VBA to evaluate the expression:

"Selection" & string

and have it run as if it were the command "Selection.Font.ColorIndex =
4"?

Thanks,
Andrew