+ Reply to Thread
Results 1 to 5 of 5

print using list box with mulitple selections

  1. #1
    Registered User
    Join Date
    10-18-2008
    Location
    michigan
    MS-Off Ver
    2010
    Posts
    88

    print using list box with mulitple selections

    Hi
    I asked this question a while back and AlphaFrog helped me.
    Thank you AlphaFrog
    I am finally able to work in the workbook.
    I changed MultiSelect in the properties box from 0-MultiSelectSingle to
    1-MultiSelectMulti
    When I click on the Command button nothing happens.

    I have a userform in sheet 2 that refers to data in sheet 1
    I’m trying to have multiple choices print.
    The list box contains the letters A to Z,
    Here is the code for the command button: I shortened it for clarity:
    HTML Code: 
    A-A sends the cursor to sheet 1 where the ranges A to Z are.
    AA-A sends the cursor back to sheet 2

    I changed the MultiSelect back to 0-MultiSelectSingle to make sure the code works.
    It did.

    Mike

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,274

    Re: print using list box with mulitple selections

    Something like this.

    Please Login or Register  to view this content.
    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.

  3. #3
    Registered User
    Join Date
    10-18-2008
    Location
    michigan
    MS-Off Ver
    2010
    Posts
    88

    Re: print using list box with mulitple selections

    Hi bakerman2

    I changed my code to yours, but I kept my Case Is...

    still doesn't print


    Mike

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,274

    Re: print using list box with mulitple selections

    Tested this time.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    10-18-2008
    Location
    michigan
    MS-Off Ver
    2010
    Posts
    88

    Re: print using list box with mulitple selections

    Hi bakerman2

    Worked like a charm

    Thank you

    Mike

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] List box selections to transfer to one cell with a comma between selections
    By ArthurWrightis in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-04-2014, 10:51 PM
  2. Looping through list box selections to print range to PPTX
    By e30325i in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2014, 02:10 PM
  3. [SOLVED] Extracting mulitple selections from a multi column listbox
    By BeginnerVBA in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2014, 04:55 PM
  4. Replies: 0
    Last Post: 06-01-2012, 12:06 AM
  5. List Box Selections Outputting Multiple Selections with One Click
    By Mordred in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-21-2011, 12:27 PM
  6. Multiple selections from a pick list - only unique selections (no repeats) ?
    By opsayo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2011, 06:25 PM
  7. [SOLVED] Print selections from a list
    By gmoexcel in forum Excel General
    Replies: 1
    Last Post: 12-07-2005, 02:45 PM

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