Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default More help needed with listboxes


Hi,
I need to copy the list from one list box to another with a comman
button like 'select all'.

Please help me out ...........

Thanx,
Viswanthan

--
viswanthankPosted from http://www.pcreview.co.uk/ newsgroup acces

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default More help needed with listboxes

Try the following code:

Me.ListBox2.List = Me.ListBox1.List


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"viswanthank" <viswanthank.1qd7ia@ wrote in message
...

Hi,
I need to copy the list from one list box to another with a
command
button like 'select all'.

Please help me out ...........

Thanx,
Viswanthank


--
viswanthankPosted from http://www.pcreview.co.uk/ newsgroup
access



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default More help needed with listboxes


Hi I tried this but it copies only the first column. I need to cop
atleast 2 of the 5 columns in the first list

--
viswanthankPosted from http://www.pcreview.co.uk/ newsgroup acces

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default More help needed with listboxes


Hi I got it to work. All i needed to do was to ssay somewhere the numbe
of columns on the second listbox.

Than

--
viswanthankPosted from http://www.pcreview.co.uk/ newsgroup acces

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
listboxes [email protected] Excel Programming 2 March 30th 05 06:41 PM
listboxes [email protected] Excel Programming 3 February 22nd 05 04:01 PM
listboxes [email protected] Excel Programming 2 February 22nd 05 10:31 AM
Listboxes 2 Denise Excel Programming 2 June 8th 04 06:39 PM
Listboxes Lionel Fridjhon Excel Programming 0 April 5th 04 06:28 PM


All times are GMT +1. The time now is 06:03 AM.

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

About Us

"It's about Microsoft Excel"