Im trying to change the color of a text box on a sheet using a macro. The following code is creating a runtime error 424:
Please Login or Register to view this content.
Im trying to change the color of a text box on a sheet using a macro. The following code is creating a runtime error 424:
Please Login or Register to view this content.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Produces the same error.
... where Sheet1 is the sheet name in the first line and the codename in the second.Please Login or Register to view this content.
The top one returned this error: Unable to get OLEObjects property of the worksheet
and the bottom one returned the error: Run time Error, Object Required
They both work fine here.
It must be an ActiveX textbox, you must use the correct name, it must be on a worksheet, the sheet name has to be correct for the first line to work, and the codename has to be correct for the second line to work.
Works fine for me.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks