Hi
Is it possible to print the listbox from the userform, if I add a "print" button?
If you click "search button" and type banana and you will see the list of all the banana that has been selected.
Will I be able to print this?
See attachment.
Thanks.
You can transfer the ListBox content to a temp sheet and print that, afterwards deleting the temp sheet.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Ok. Thank you bakerman2
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks