Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to print all columns from a multi column listbox?
Hi all, i have a 4 column listbox on a userform populated like this: VBA Code: -------------------- With UserForm1.ListBox1 .AddItem rng.Address .List(.ListCount - 1, 1) = rng.Offset(0, -29).Value .List(.ListCount - 1, 2) = rng.Offset(0, -25).Value .List(.ListCount - 1, 3) = rng.Offset(0, -24).Value ic = ic + 1 End With -------------------- i now want to print all 4 columns as seen in the listbox, could someone explain how? -- Simon Lloyd Regards, Simon Lloyd 'Excel Chat' (http://www.thecodecage.com/forumz/chat.php) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=191929 http://www.thecodecage.com/forumz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi Column Listbox Help | Excel Programming | |||
Multi Column UserForm ListBox | Excel Programming | |||
(repost) Listbox Rowsource Headings Multi columns | Excel Programming | |||
Multi-column ListBox. Multiple bound columns??? | Excel Programming | |||
Multi-columns in a ListBox | Excel Programming |