Share via

Could not set the Name property. Ambiguous name.

Anonymous
2010-07-27T01:09:15+00:00

I receive this error when trying to change the Name property of TextBox1. It seems to me that it has a period in there, not sure, but I cannot get rid of it either.

Any idea on what to do?

TIA.

Hernan.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2010-07-27T03:21:43+00:00

I just looked at the workbook you sent me. It won't let you rename the TextBox to txtName because the first Label control on the UserForm is named that... you cannot have two controls (even if they are different kinds of controls) with the same name. You might consider renaming your Label control lblName and then you will be able to name your TextBox to txtName if you want.

Was this answer helpful?

2 people found this answer helpful.
0 comments

Answer accepted by question author

Doug Robbins - MVP - Office Apps and Services 323K Reputation points MVP Volunteer Moderator
2010-07-27T02:22:05+00:00

What is the name that you are trying to use?

Is there a possibility that you already have a control to which that name has been assigned on your form.

In the code pane, if you click on the left hand pulldown at the top of the pane, you will see a list of all of the objects that you have on the form.

Doug Robbins - Word MVP dkr[atsymbol]mvps[dot]org

Was this answer helpful?

2 people found this answer helpful.
0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-07-27T01:24:47+00:00

    Where is the TextBox located at... a UserForm or on the worksheet? If on the worksheet, what is the name of the worksheet.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2010-07-27T02:54:03+00:00

    Right, and no, I don't have anything weird or named the same way.

    TextBox1 cannot be renamed to txtName

    Totally weird. Would you like me to send you the workbook which has the form?

    I don't know if i can attach anything here, but I cam email it to you.

    Thanks again.

    Hernan.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2010-07-27T01:52:08+00:00

    Hello Rick:

    It is in a userform.

    Thank you for replying.

    Hernan.

    Was this answer helpful?

    0 comments