View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 363
Default Gaining the correct Listbox Column value

I have a listbox(Listbox4) that i have set to :

ColumnCount = 3

with the BoundColumn=1

When i populate the listbox, i also list the values in a more viewer friendly way by placing a (&
vbtab &) in between each Column value.

Now i need to place the value that was selected in listbox4 (the 1st value on the Left Column) as :

Range("B2").Value = ListBox4.List(ListBox4.ListCount - 1, 1) <=== This does not seem to be the
correct value to be placed into cell(B2).

How can i get the value that is the LEFT most value in Listbox4 to be placed into Cell(B4) ?

Corey....