Posted to microsoft.public.excel.programming

jindon[_50_] jindon[_50_] is offline

external usenet poster

Posts: 1

listbox to cells??

Code
-------------------

Dim i As Integer, n As Integer
With Me.ListBox1
For i = 0 To .ListCount - 1
If .Selected(i) Then
n = n + 1
Sheets("Sheet1").Cells(n, "a").Value = .ListIndex(i)
End If
Next
End With

-------------------

--
jindo
-----------------------------------------------------------------------
jindon's Profile: http://www.excelforum.com/member.php...fo&userid=1313
View this thread: http://www.excelforum.com/showthread.php?threadid=55070

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
data from listbox to cells	Buddy Lee	Excel Programming	2	October 24th 05 09:56 PM
Insert cells in a ListBox	Stift[_7_]	Excel Programming	4	May 21st 04 12:02 PM
Linking Cells to ListBox - How?	William C. Smith	Excel Programming	2	December 29th 03 10:53 PM
listbox.value not equal to listbox.list(listbox.listindex,0)	ARB	Excel Programming	0	October 22nd 03 12:46 AM
Sorting ListBox results or transposing ListBox values to other cells for sorting	Rob[_8_]	Excel Programming	1	July 9th 03 04:35 AM

All times are GMT +1. The time now is 12:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us