Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 557
Default List Listbox data in column

Hi all, How can i list all data of a Listbox in a cloumn
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 236
Default List Listbox data in column

Dim i As Double
On Error Resume Next
For i = 0 To Me.ListBox1.ListCount
Application.ActiveCell.Offset(i, 0).Value = _
Me.ListBox1.List(i)
Next i

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"K" wrote:

Hi all, How can i list all data of a Listbox in a cloumn
.

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
List Listbox items in column by macro K[_2_] Excel Programming 0 March 16th 10 08:30 AM
How to right-align data in a column of a listbox? Stefano Gatto Excel Programming 0 May 10th 06 08:28 PM
ListBox ( finding supporting data not in the list) TK Excel Programming 0 August 31st 04 03:37 AM
Using Listbox to specify data in list to enter in textboxs dht Excel Programming 0 June 24th 04 02:42 PM
listbox.value not equal to listbox.list(listbox.listindex,0) ARB Excel Programming 0 October 22nd 03 12:46 AM


All times are GMT +1. The time now is 10:53 PM.

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"