Only Visual Basic code can be used with the VBA editor. Type "end function" or "end sub" at the end of your script if it is not placed there automatically after your initial declaration.

Launch Excel and click the "Developer" tab above the ribbon menu; then click the "Visual Basic" button. Type "Sub ConvertToText()" (without quotation marks) into the code pane.