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.

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.

My list is over 50.

I figured out how to set the column widths. Now I am left with:

Is there any way to the value from both columns to be placed 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



"Jim at Eagle" wrote in message
...
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.

It sounds like homework time.
http://www.contextures.com/index.html


"Patrick Simonds" wrote:

My list is over 50.

I figured out how to set the column widths. Now I am left with:

Is there any way to the value from both columns to be placed 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



"Jim at Eagle" wrote in message
...
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.

index = listbox1.Listindex
range("A1") = listbox1.List(index,0)
range("B1") = listbox1.List(index,1)

"Patrick Simonds" wrote in message
...
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.