Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Adding items to the second column of a list box

Hi,

I am populating from a one dimensional array.

I have two one dimensional arrays, so I want to populate
the first column with values from the 1st array, and the
second coumn with values from the 2nd array.

Thanks,
mika
-----Original Message-----
if you are using the rowsource or listfillrange, just set

the reference to
two columns

Sheet1!A1:B20

Also, set the columncount property to 2

if not, how are you populating the listbox?

--
Regards,
Tom Ogilvy

"mika" wrote in

message
...
Hi,

I have a 2-column list box, but I can't figure out how

to
add items to the second column. Any help would be

greatly
appreciated.

Thanks,
Mika



.

Reply
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
Adding some list items Jeremy Excel Discussion (Misc queries) 1 April 19th 10 08:19 PM
Adding/deleting items from a pivot table dropdown list Joe Excel Discussion (Misc queries) 0 August 26th 09 07:17 PM
adding a formula to items in a drop down list tom Excel Discussion (Misc queries) 0 November 25th 08 02:23 PM
Adding items on an existing drop-down list Kumiko17 Excel Discussion (Misc queries) 2 November 14th 06 03:19 PM
I have a question about adding information to a list of items that have cells linked to another worksheet. Marc Excel Discussion (Misc queries) 1 July 9th 06 05:27 AM


All times are GMT +1. The time now is 05:35 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"