mikeJW
Mechanical
- May 2, 2003
- 21
I am trying to use the text parameter of one shape to determine a number and use this in a shapesheet formula for another shape.
In particular I am using VB to write a string (number) to the text parameter of one shape.
The shapesheet for another shape should be able to use the numeric value of the text in its formulas.
The method is (supposed to) use EvalText.
I cannot get any numeric value from EvalText.
Can anyone provide a working example which converts the text from one shape to a cell value in another shape?
I may be wrongly addressing. My permutations either return value 0 or give an error message.
Many thanks.
In particular I am using VB to write a string (number) to the text parameter of one shape.
The shapesheet for another shape should be able to use the numeric value of the text in its formulas.
The method is (supposed to) use EvalText.
I cannot get any numeric value from EvalText.
Can anyone provide a working example which converts the text from one shape to a cell value in another shape?
I may be wrongly addressing. My permutations either return value 0 or give an error message.
Many thanks.