Thread: Strings
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default Strings

In Excel 2000 VBE want's str as Object
And needs the Set instruction

Dim str As Object

Set str = UserForm1.CheckBox1
str = 1
UserForm1.Show


I don't know how to make it work from a string
--
steveB

Remove "AYN" from email to respond
"Aran" wrote in message
...
Hello
I have a question about strings
How do i make the value runnable
ex.
str = "checkbox1"
and i like to use the string instead of the name checkbox1
and do this
checkbox1.value = 10

or if the string contain a name of a funktion how to run that with the
string

i hope you understand my question
thanks