mapping drop box result to a cell

First off, I'll explain the procedure that I have conducted so far:

1) I inserted date between cells A1-A3. I then named the range "name"

2) I inserted a combo box (form control), to which I assigned the input range "=name"

Now, what I am hoping to achieve is whatever i select via the drop box, I will be able to get the result on a different cell eg: if i choose "dave" on the drop box, I must get "Dave" on cell D1.

I tried applying the cell link, but that only gives me the ordinal value.

Is there something that I have to program on Visual Basic or otherwise?

Any assistance is grateful.

Boos

If I used LinkedCell: Dave and ListFillRange: Name, then I get Dave in D1 if I select Dave...

Sorry, I thought you were talking about the Control Toolbox, you used Forms Toolbox.

If you want the result in D1, then change the linked cell to something else to hold the index number... say E1

Then in D1: =INDEX(Name,E1)

Right Click the control & choose Format Control

I used the combox from the Controls Toolbox,

Then you rightclick the control and select Properties, then enter D1 for LinkedCell and Name for ListFillRange.

You will need to get out of Design Mode to activate and use (click the DesignMode button)