Creating Dynamic code in Excel Macro

[Perception]

Hi

I have an excel 2003 macro with an internal string array ValueX()
I want to be able to, in effect, put some text into a cell in a worksheet that will be used by the Macro as if it was a formula in the cell.
For example, I might put a piece of text such as “=LEN(Valuex(7))” into a cell in a worksheet. LEN is only an example. It could be any Excel Function
I need the VBA macro to access that cell and set a variable to the calculation the length of the string in Valuex(7))
I assume this could be done by dynamically creating the code in the Macro
Could anyone tell me how this is achieved
Thanks in advance for your assistance

Ian

[Bob Phillips]

Please Login or Register  to view this content.

for example

[Perception]

Bob

Thank you

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save