Listbox-setup and read

dcoons

Board Regular
Joined
Apr 21, 2002
Messages
56
Hi!

I need to setup and be able to 'read' a listbox. I've been able to get started w/a listbox control, but need some help understanding how to get data out. I've been playing with a bound list box, but am not sure I can do what I want that way.

I have a list of 200 markets in one column and and the percent US they represent next to the names:

Albany, NY 1.05
Detroit, MI 3.20
San Francisco, CA 2.22
etc.

These 200 markets go into the list box. I'd like to know if I can keep the marketnames left justified, and the percentUS right justified w/2 decimal places.

I'm using the fmListStyleOption which shows checkboxes--I like the way it looks, but don't actually need the checkboxes and could live without, but I do need multi-select.

What I need to "read" from the list is the number of markets selected, and the total coverage of the US (sum of pcts) when ever they change. These two items need to go into cells somewhere on the sheet.

Any help greatly appreciated!

Thanks,
Dale
 

Forum statistics

Threads
1,085,335
Messages
5,383,032
Members
401,812
Latest member
topherj09

Some videos you may like

This Week's Hot Topics

Top