I bet you could have used a combobox from the control toolbox toolbar to
accomplish the same thing.

But if the linked cell is A1 and the list is in a named range "myList", then you
could use another cell to get the value shown in the dropdown.

=if(a1=0,"",index(mylist,a1))

Atishoo wrote:

Need help fast!!
Im have meade a combo box from the forms menu (hads to be from the forms
menu as im using vba to dynamically change the list fill range according to
the active cell)
I linked the combo box to a worksheet cell but all it gives me is the number
of the row I select in the drop down not the actual item selected!
Have tried allsorts and am now desperate!!

--

Dave Peterson