424 Object required on SOME versions of Excel

Hi all

I have a small application in Excel's VB. When I try to use it, all I get is the "Run time error 424 Object required" error.

However, one of my friend's said it worked without any problem.. I have used Excel 2007 and 2010, both giving me the error.

The line with the problem is highlighted in green:

Please Login or Register  to view this content.

Hi.
Welcome to the forum. Upload the workbook and there will be people willing to help.
For start you can check for any missing references in VBE->Tools->References. Maybe there is some additional control that is available on your friend's computer, but is missing on yours.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

Are you sure your control is called Textname?

well, as Rory suggested there is no control "TextName" nor radio buttons on the form
there is no way this works on any friend's computer

It is a missing object.
You have a reference set to the Microsoft Data Formatting Object library, which I do not have, so the control is not present and I too get the Object Required error on that line.

@Rory - I don't have missing references and I still get the error.
@mike I see user form with 3 text boxes, 2 command buttons and a frame. Is that all that is supposed to be on the form?

Mike, please, be serious ... I don't see the problem to admit that you are trying to adjust some code found on Internet. The code behind the form has nothing to do with the controls present on the form

Erm FYI, this video shows it is WORKING:

Probably what you were after:

well, it's obviously not the same app. and here is how it looked the original form for that code