Problems adding an object to a user form in VBA

Copper Contributor

When I try to add an object, such as a button or label, to a form it marks the following error: "Error accessing OLE record." How can I fix it?

1 Reply

@Israel98 

The error message “Error accessing OLE record” can occur when you try to add an object such as a button or label to a form in VBA. 

This error message can occur when there is already another ADO connection attached to Excel. 

To fix this error, you should make sure that you only open the connection once and then close it when you are done working with it.

 

I hope that helps!

NikolinoDE

I know I don't know anything (Socrates)