What is the difference between DIM as Object and DIM as OLEObject?

[brharrii]

As indicated in my title, I'm trying to understand the difference between declaring all of my checkboxes as objects or as OLEObjects. Does it make a difference which one I do?

Thanks

[Norie]

Object is any object, it could be a shape, a worksheet, a range, another application etc

OLEObject is specifically for an OLE object.

You could use Object for an OLEObject but you wouldn't be able to use OLEObject for all the other objects.

[Jakobshavn]

DIM'ing properly helps the AutoComplete function present good options.

[brharrii]

ah ok, How can I tell if the object that I'm using is specifically an OLE object or if it is just a regular object?

Thanks again

[Norie]

Why do you need to?

[brharrii]

I'm trying to implement code that when a button is pressed all check boxes on the active sheet will be set to unchecked. I don't know if it would be more appropriate to dim them as ole objects or regular objects.

[Norie]

How are you identifying the checkboxes?