Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Shape text to number conversion. How? 1

Status
Not open for further replies.

mikeJW

Mechanical
May 2, 2003
21
0
0
GB
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.
 
Replies continue below

Recommended for you

Status
Not open for further replies.
Back
Top