[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Re: Convert String variable to code

Bob Phillips

12/11/2006 8:21:00 PM

Surely

sProperty = textbox1.tag
msgbox("Custom Object Property = " & sProperty)

gets what you want?


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Hokievandal" <Hokievandal@discussions.microsoft.com> wrote in message
news:8BA08DC2-3667-45BE-9E61-523A9BCB7F13@microsoft.com...
> Hello all,
> Is there a way to pass a string variable such as "textBox1.visible=true"
> to
> be read as code? I'm wanting to store short object properties within
> control
> tags to reduce code so that the program can loop through several text
> boxes
> and return values using the text in the control tag.
>
> Simplified example;
>
> dim Task as CustomObject
> sProperty = textbox1.tag
> msgbox("Custom Object Property = " & task.sProperty)
>
> Thanks!


1 Answer

Bob Phillips

12/11/2006 11:40:00 PM

0

Is the user input the control name? If so,

MsgBox Me.Controls(sStringCommand).Left

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Hokievandal" <Hokievandal@discussions.microsoft.com> wrote in message
news:A93A4922-FA91-47FD-901A-DC3D3D806029@microsoft.com...
>I didn't state my question very well. Instead, how could i make the
> following work?
> Dim sStringCommand as String
>
> sStringCommand = "msgbox("Enter Name:")
> call sStringCommand and have the code 'MsgBox... ' run
>
> Thanks again,
> Ryan
>
>
>
> "Bob Phillips" wrote:
>
>> Surely
>>
>> sProperty = textbox1.tag
>> msgbox("Custom Object Property = " & sProperty)
>>
>> gets what you want?
>>
>>
>> --
>> ---
>> HTH
>>
>> Bob
>>
>> (change the xxxx to gmail if mailing direct)
>>
>>
>> "Hokievandal" <Hokievandal@discussions.microsoft.com> wrote in message
>> news:8BA08DC2-3667-45BE-9E61-523A9BCB7F13@microsoft.com...
>> > Hello all,
>> > Is there a way to pass a string variable such as
>> > "textBox1.visible=true"
>> > to
>> > be read as code? I'm wanting to store short object properties within
>> > control
>> > tags to reduce code so that the program can loop through several text
>> > boxes
>> > and return values using the text in the control tag.
>> >
>> > Simplified example;
>> >
>> > dim Task as CustomObject
>> > sProperty = textbox1.tag
>> > msgbox("Custom Object Property = " & task.sProperty)
>> >
>> > Thanks!
>>
>>
>>