Jacob Edison
01-26-2011, 01:03 AM
Hi everyone,
Finally found my user name and password for vbeexpress... :)
ok, let me get to my question.
I have a check box ("CB1") on a worksheet (say "Sheet1").
I'm trying to use VBA to check / uncheck the Check box. Normally i user the following
CB1.Value = True
However, i have several Check Boxes on the form, so I declare a Variable (Dim iName As Variant) to store the name of the Check Box
Now is there a way I can Use this to reffer to by check box. Something like
Me.Controls(iName).Value = True
When ever I try this it says "Compile error: Method or data member not found"
Can someone please :help :help :help :help !!!
Finally found my user name and password for vbeexpress... :)
ok, let me get to my question.
I have a check box ("CB1") on a worksheet (say "Sheet1").
I'm trying to use VBA to check / uncheck the Check box. Normally i user the following
CB1.Value = True
However, i have several Check Boxes on the form, so I declare a Variable (Dim iName As Variant) to store the name of the Check Box
Now is there a way I can Use this to reffer to by check box. Something like
Me.Controls(iName).Value = True
When ever I try this it says "Compile error: Method or data member not found"
Can someone please :help :help :help :help !!!