running a private sub macro

hello everyone, i have been searching the internet for an answer for my problem... i have a macro that shows a user form and asks the user to fill up certain fields. there is one point wherein i want to automatically get the total of all numeric data entered in assigned textboxes. I tried running the application through calling another macro everytime a textbox gets updated. but there is always a problem... my sample code is shown below... i hope someone can help me with this one.

Please Login or Register  to view this content.

everytime i run the macro, i get runtime error '1004'....

This is your macro for the UserForm only? Do you have other macros within the same worksheet? Can you attach a sample workbook?