Syntax error in writing code to reference a VBComponent

Trying to write code to add ActiveX Command button to search Column C for names. Script to add button works fine when I paste it into the code associated with the button but I'm unable to decipher how to write the code as a string. I want to do this because each day I regenerate this sheet with new data and I don't want to manually add the code in every day. The error I get is "Compile error: Syntax error". The error is arising from what comes after codeText. Any help would be greatly appreciated. Thanks.

Please Login or Register  to view this content.

Thanks 6StringJazzer! Your suggestion led to my finding other errors but it works great now! Below is the working code:

Please Login or Register  to view this content.