how long is your list? If it's less then 30 or so you may want to use the
menu-data-validation (allow) list and then program out the code to handel or
use VLOOKUP function.

"Patrick Simonds" wrote:

Is there any way to set the column widths in a list box? My ListBox has two
columns, but I want to reduce the space between column one and two.

Also is there any way to the value from both columns into separate cells. My
list is two columns wide column one being the name and column two being the
work shift assigned. The name would go into the active cell and the work
shift in to the next cell down.