Posted to microsoft.public.excel.programming

dht[_2_]

external usenet poster

Posts: 13

Multicolumn Listbox with variable range

I'm trying to create a listbox in a user form (C_Panel) that is multicolumn,
and references a two column but variable row range (A2 to B?). Can someone
point me to how to do this.

Also how do I get the listbox to automatically reflect any changes to the
range or does it do it automatically?

Using Excel 2000

Thanks
David

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
multicolumn listbox move or value set	Andrew Smith	Excel Programming	3	August 25th 04 05:18 AM
Reordering with Multicolumn Listbox	asmenut	Excel Programming	2	August 17th 04 01:53 PM
Multicolumn Listbox and ordinary listbox	Ron_D	Excel Programming	0	June 4th 04 08:56 PM
multicolumn Listbox and textalignment	John Holland	Excel Programming	3	September 11th 03 01:45 AM
Values in a MultiColumn Listbox	Tom Ogilvy	Excel Programming	5	September 5th 03 08:30 PM

All times are GMT +1. The time now is 04:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us