| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
evaluation a variable in an expression
You can do a few things with CallByName. E.g,.
Debug.Print CallByName(CallByName(Selection, "Font", VbGet), "ColorIndex", VbGet) = 4 You can nest CallByName's to get the property value you need. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chip Pearson" wrote in message ... I don't believe there is any way to do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message oups.com... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Performance Evaluation | Excel Discussion (Misc queries) | |||
| Formula evaluation | New Users to Excel | |||
| Options Evaluation | Excel Worksheet Functions | |||
| variable not equal to expression | Excel Programming | |||
Threaded Mode
