LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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....



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sum of digits in column not giving correct sum Mary Beth Excel Worksheet Functions 3 January 30th 09 01:09 AM
MAX returns correct column, but row -1? Ryan[_2_] Excel Worksheet Functions 3 July 7th 07 01:22 AM
Gaining the Column A Value Corey Excel Programming 8 March 23rd 07 03:53 PM
what is the correct formula to add a column with =sum Thomas Flaherty New Users to Excel 3 August 30th 06 05:00 AM
filling a two column listbox from a two column recordset Dennis Excel Programming 5 May 23rd 04 10:13 PM


All times are GMT +1. The time now is 04:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"