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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.