PDA

View Full Version : Solved: print contents of a list box?



gibbo1715
10-10-2005, 11:13 AM
All

I ve search the kb and forum and cant find this (unless i missed it),

What I need to be able to do is print the contents of a list box,

Is this possible?

Cheers

Gibbo

Bob Phillips
10-10-2005, 11:50 AM
You could dump it to a worksheet range and then print that


With UserForm.Listbox1
Range("A1").Resize(.ListCount, 10).Value = .List
End With

gibbo1715
10-10-2005, 01:00 PM
Thanks, I ll give it go, whats the 10 mean?

Cheers

Gibbo

Bob Phillips
10-10-2005, 01:20 PM
Thanks, I ll give it go, whats the 10 mean?

Cheers

Gibbo

Number of columns.

gibbo1715
10-10-2005, 01:24 PM
great, thanks very much

gibbo