+ Reply to Thread
Results 1 to 5 of 5

Print items from a listbox

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    Porto
    MS-Off Ver
    Excel 2010
    Posts
    94

    Print items from a listbox

    hey everyone.

    I want to print all the items I have in a listbox, but it's not working.

    palete.png

    As you can see I have 4 items in this example , but when I try to pass them to my file, it only goes the first item.

    I was writing this
    Please Login or Register  to view this content.
    but it doesn't seems to work.

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-27-2013
    Location
    Porto
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Print items from a listbox

    can anyone help me?

  3. #3
    Forum Contributor thameem127's Avatar
    Join Date
    04-06-2012
    Location
    Jeddah,Saudi Arabia
    MS-Off Ver
    Excel 2003,Excel 2007
    Posts
    321

    Re: Print items from a listbox

    Upload a file same as attached png. I can solve it.

  4. #4
    Registered User
    Join Date
    02-27-2013
    Location
    Porto
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Print items from a listbox

    I can't upload only that file, because then it's not going to work. And I cannot send you all the programm.

    But, If you want, I can send you only that userform with the code in it.

    I just want that the items in the listbox appear in that file to get printed..

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    This will only put one value in C7 on Imprimir3.
    Please Login or Register  to view this content.
    If you want to put all the values from the listbox on the sheet you'll either need to resize the destination range or use a loop.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1