You could replace the Listbox from the Forms toolbar with a listbox from the
Control toolbox toolbar.

That will have the behavior that you want (the linked cell will show the
displayed choice).

But you could use the listbox from the Forms toolbar and a couple of cells--one
cell for the link and one cell showing the value...

For instance, if your list is on a sheet (say Sheet99 in A1:A10) and your linked
cell is on sheet1 in A1, you could use:

=if(a1=0,"",index(sheet99!a1:a10,a1))

The linked cell returns an index (1 to how many entries) into the listbox's
list.

I don't know of any links for the listbox, good or bad.

Fan924 wrote:

I am using a list box from the forms toolbar. This is new for me. I
loaded 10 numbers of 4 digits. The output is numbers 1 to 10. I would
rather it output the 4 digit numbers instead. It looks like this is
not an option. Are there any good links on the list box? I have found
many of the bad ones.

--

Dave Peterson