Solved: print contents of a list box?

[gibbo1715]

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]

You could dump it to a worksheet range and then print that

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

[gibbo1715]

Thanks, I ll give it go, whats the 10 mean?

Cheers

Gibbo

[Bob Phillips]

Thanks, I ll give it go, whats the 10 mean?

Cheers

Gibbo

Number of columns.

[gibbo1715]

great, thanks very much

gibbo