Cell link in a form listbox - can it show a word?

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

When I make a listbox with a range of words instead of numbers, the listbox
shows the words but the cell link cell shows 1 if it is the first word, 2 if
second, etc. Is there a way to make it show the word in the cell link?
Thanks
 
You can use a helper cell to translate that number to the words.

=index(rangeofwords,linkedcell)
 
Back
Top