Object required Error in running the macro

I am getting an error as "Object required" while running the macro which i have assigned to a text box.

I have copied the macro from another excel which has only one sheet. This is working fine there and generating the insert script based on the data in the sheet.

This macro i am inserting it in another workbook in the 4th sheet (this workbook has 4 sheets). Below is the macro used :

Please Login or Register  to view this content.

End Sub

Is it something with the way i am doing a copy and paste ?

you didn't say WHERE the code error happens.

if its the DIM ...FIND, then put the find in its own line outside of the dim.
DONT use colons to separate commands.

Do you have a userform called OutputForm in that workbook?
If so does it have a textbox called txtOutput?

Originally Posted by ranman256

DONT use colons to separate commands.

That is a style preference (yours maybe not ours), not a rule.