A combo box from the Forms toolbar will return the index number to the
linked cell.

--
Biff
Microsoft Excel MVP


"Neil Pearce" wrote in message
...
All,

In design mode I have created a combo box. I have inputted the
'ListFillRange' & 'LinkedCell'.

However when I select an input from the croll bar the link cell doesn't
place a ref nr but the text of the selected input instead! Any ideas how
to
change this?


Cheers,

Neil