"Could not set the Name property. Ambiguous name"

**JessFace** · 01-12-2011, 02:36 PM

Hi there,

I am working on coding a userform. My fields are code, project name, project lead, project assist, priority, tasks, start date, duration, % complete, end date, status and comments.

I want to be able to enter multiple tasks for one project but I can not get the code right. I have five fields under tasks so that I can at least enter five at a time for one project, the field textbox is called "txtTasks" and when I enter the same name for the textbox below it I get the following message "Could not set the Name property. Ambiguous name".

Is there a way to code them so that the tasks can be entered and listed one under another?

Thank you for your time.

**shg** · 01-12-2011, 02:46 PM

You can name them txtTask1, txtTask2, ...

**JessFace** · 01-12-2011, 02:48 PM

Thank you, I will try that.

These will all go under a column named "Tasks" in my spreadsheet, will that still work?

**shg** · 01-12-2011, 02:50 PM

You said these were on a userform

**JessFace** · 01-12-2011, 02:55 PM

Yes, and once I enter the data on the form i will click "Add" and the information will copy over onto my spreadsheet.

**royUK** · 01-12-2011, 02:55 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!