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
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