Excel type calculation

[Paul Remblance]

Is there a 'simple' way to perform a calculation on a textbox entry similar
to Excel. For example: if the user enters =2*3 the validated event changes
it to 6.

 

[Larry Lard]

Is there a 'simple' way to perform a calculation on a textbox entry similar
to Excel. For example: if the user enters =2*3 the validated event changes
it to 6.

In the old days this would have meant lexing the input, building a
parse tree, and walking that to produce a result. These days, we have
the (to my mind extremely elegant) method of using regexes to do all
the work. See for example

<http://www.devx.com/vb2themax/Tip/19438>

or just google for regex expression evaluator.

 

[Paul Remblance]

In the old days this would have meant lexing the input, building a
parse tree, and walking that to produce a result. These days, we have
the (to my mind extremely elegant) method of using regexes to do all
the work. See for example

<http://www.devx.com/vb2themax/Tip/19438>

or just google for regex expression evaluator.

Not what I would call 'simple' but it works fine, many thanks.