| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to evaluate string?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to evaluate string?
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to evaluate string?
You didn't understand what I need. I need evaluation of variable so that evaluation returns reference to some variable. I want to evaluate string "TextBox1" which is actually object on a form and I need some function (or something) to evaluate that and to return object "TextBox1" to some variable. -- Boban ------------------------------------------------------------------------ Boban's Profile: http://www.excelforum.com/member.php...o&userid=28560 View this thread: http://www.excelforum.com/showthread...hreadid=482210 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to evaluate string?
Dim objvar as MSForms.Textbox
set objvar = Userform1.Controls("Textbox1") or sStr = "TextBox1" set objvar = Userform1.Controls(sStr) -- Regards, Tom Ogilvy "Boban" wrote in message ... You didn't understand what I need. I need evaluation of variable so that evaluation returns reference to some variable. I want to evaluate string "TextBox1" which is actually object on a form and I need some function (or something) to evaluate that and to return object "TextBox1" to some variable. -- Boban ------------------------------------------------------------------------ Boban's Profile: http://www.excelforum.com/member.php...o&userid=28560 View this thread: http://www.excelforum.com/showthread...hreadid=482210 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to evaluate string?
Yes, thats what I needed! Thanks, have a drink on my account! Tom Ogilvy Wrote: Dim objvar as MSForms.Textbox set objvar = Userform1.Controls("Textbox1") or sStr = "TextBox1" set objvar = Userform1.Controls(sStr) -- Regards, Tom Ogilvy -- Boban ------------------------------------------------------------------------ Boban's Profile: http://www.excelforum.com/member.php...o&userid=28560 View this thread: http://www.excelforum.com/showthread...hreadid=482210 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a function that will evaluate a text string in a cell? | Excel Worksheet Functions | |||
| Evaluate text string as a function | Excel Discussion (Misc queries) | |||
| Evaluate and execute a string | Excel Programming | |||
| Evaluate string as a formula | Excel Worksheet Functions | |||
| how to evaluate the content of a string as if it was a formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
