Strings
Hello
I find out how to do
ActiveSheet.OLEObjects(str).Visible = True
worked fine
but i still have the question about how to run a funktion
"aran" wrote:
Thanks
Thats worked fine with the value but if i try visible it say that
the method is not supported
And if i like to run a funktion the same way how do i do
"Bob Phillips" wrote:
No problems Aran, just making sure.
I Assumed userform checkbox.
If it is a control toolbox checkbox, use
ActiveSheet.OLEObjects(str).Object.Value = True
If it is a forms checkbox, use
ActiveSheet.CheckBoxes(str).Value = True
--
HTH
RP
(remove nothere from the email address if mailing direct)
"aran" wrote in message
...
Sorry about my example
i have the checkboxes on a worksheet
and when i try your example it say it cant find the method "controls"
"Bob Phillips" wrote:
Me.Controls(str).Value = True
BTW you cannot set a checbox value to 10, just True or False.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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
|