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

You can use a helper cell to translate that number to the words.

=index(rangeofwords,linkedcell)



Jim wrote:

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

--

Dave Peterson