Try something like

MsgBox Evaluate(Me.Controls("TextBox1").Text)

You should probably put in some error checking to ensure that the
Text is numeric.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Boban"
wrote in message
...

I have TextBox1 control on Form.

I want to know how to evaluate string "TextBox1" as object?

What I want is something like this:

objectvar = Evaluate("TextBox1")

I want to pass to objectvar evaluated string "TextBox1" and
because
TextBox1 is object it should be evaluated as object. How to do
that?


--
Boban
------------------------------------------------------------------------
Boban's Profile:
http://www.excelforum.com/member.php...o&userid=28560
View this thread:
http://www.excelforum.com/showthread...hreadid=482210