OleoObject name variable definition

[mmf]

hI guys
I am trying to generate a sub that read the name of a check box (which is in text format) in a spreadsheet in this case sheet13 and according to that ask if that check box which is in another sheet (sheet4) is true or false, I mean if it checked or not, then perform other actions

But I am getting this following error
Run time error ‘438’
Object doesn’t support this property or method

I tried several things but always get an error.
Does some body know how to make the checkboxname variable a valid name for the checkbox object in sheet4?

Best regard to all

Please Login or Register  to view this content.

[mmf]

hello, does anybody have a light here?
thanks folks

[shg]

Be easier if you'd share the line that has the error ...

Is the checkbox from the Control Toolbox?

[mmf]

sorry Shg, is because I am quite un expert with VBA some time is also difficult for me to explain the error.

Yes is the checkbox from the control tool box the one that I would like to know how should be declared in order to pick the name from sheet13 in a workbook, and check if that checkbox, which is in sheet4, is cheeked or not.

I declared checkboxname as an object

Please Login or Register  to view this content.

I also set checkboxname in sheet4 but I think that is a mistake

Please Login or Register  to view this content.

And then in the code I assign the value of a cell in sheet13 (text with the name of the check box in sheet4) to the variable checkboxname

Please Login or Register  to view this content.

To finally ask if that checkbox is tick or not in sheet4 to perform other things

Please Login or Register  to view this content.

If I use the name of the checkbox directly for example

Please Login or Register  to view this content.

works ok, but because there are several switches I was thinking to use a for routine intead of many if for each switch.
I really appreciate any help with this.
Best regards to all

[shg]

I also set checkboxname in sheet4 but I think that is a mistake

You're right, that's wrong; you set the object variable to the sheet, not the control.

You can use any of these constructs:

Please Login or Register  to view this content.

[mmf]

thanks for your time, but I still not getting the answer, and still having the trouble.
I simplify the things as follow and I am attaching a zip file with the excel sheet. What I would like to to do in this example is read the name of the check box in sheet 13, ask if the check box (which are in sheet 4) value is true if it true the write in the next cell in sheet 13 "ok"

Please Login or Register  to view this content.

[shg]

Remove the quotes around "checkboxname".

[mmf]

Hello, I did that but I get this error. Run time error 1004
method oleobjects of object _Worksheet failed.

I am not sure why I am getting that error but highlight the following line in the code

Please Login or Register  to view this content.

is like is not recognizing the checkboxname as a text

do you have any other suggestion?
cheers

[shg]

You only have three checkboxes, but 10 cells thant contain checkbox names. It errors on the fourth cell, as you would expect.

[mmf]

what a newbie.
many thanks for the help

[shg]

Been there, you're welcome.