Excel Form Tools

  • Thread starter Thread starter Clare Lang
  • Start date Start date
C

Clare Lang

Does anyone know how to use the List Index Property so that I can return
the values to a cell from the Form Toolbars Drop Down Box instead of an
index number

*****Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum & Business Software*****
 
Clare,

say the list is in c1:c8 and that the cell link (index)is in d1. now in
e1 put this formula.

=INDEX(C1:C8,D1)


Hope it helps,


Cesar Zapata
 
Back
Top