I am using XP 2002, SP1. I typically use Excel to perform simple math but
now am dabbling in some more advanced areas. Please excuse me if I misuse
any terms... I am trying to build a Dialog Box which eases data entry for
the user while still applying the Validation of List Boxes for data
selection. The Dialog Box displays several List Boxes for the user to
populate, and the Lists of data are displaying appropriately to the user.
However, when I bind the selected values of each box to another cell in my
workbook (I'm using the workbook as a source for a mail merge to a word doc),
the destination cell is returning the array value instead of the actual value
as displayed on the list. For example, the list box shows: dog, cat, mouse.
The user selects cat. The value returned in the destination cell is '2' not
'cat'.

Can anyone help me out here?

TIA
Angela