Thread: ListBox
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Simonds Patrick Simonds is offline
external usenet poster
 
Posts: 258
Default ListBox

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.