Select and Print Tables based on ListBox Selections

**canadian_chickie** · 12-10-2015, 02:04 PM

Hi All,

I have a worksheet that has multiple tables in it. The table names are based on the branch and the time of year. I'm trying to program something so that I can push a button and easily print multiple tables based on the ListBox selections.

I have 2 ListBoxes; one for the branch and another for the quarter. I need to be able to select multiple branches and quarters and have it select the appropriate tables to print ie) if I select district A and B in the branch ListBox and Q1 and Q2 in the date ListBox, it will print tables A_Q1 & A_Q2 & B_Q1 & B_Q2.
I can usually muddle my way through writing a macro, but this is the first time I have ever worked with UserForms or ListBoxes. I can probably work out the actual printing part of the macro, but I'm struggling with how to select the appropriate tables.

I have the UserForm and ListBoxes set up properly (I think!). I attached what I have so far; I think the visual will better explain what I'm trying to do. I hope I have adequately explained everything, but if I need to clarify anything, please let me know. I'm working in Excel 2007. Any assistance would be greatly appreciated!

Demo.xlsm

**jaslake** · 12-10-2015, 05:03 PM

Hi Canadian_chickie

Replace the UserForm Code with this. It appears to work for me. Please note, QuarterListBox is now a 2 Column ListBox.

Please Login or Register  to view this content.

**canadian_chickie** · 12-11-2015, 04:08 PM

Hi John,

Thank you so much, this is terrific! Could I bother you to help me with one small modification though please. I would like the print dialog box to appear instead of the document automatically printing. I tried changing the print section so the print dialog appears (which is does), but when I hit print, it's not printing the "report". I italicized the changes that I made; if you could show me where I went wrong, that would be great.

Please Login or Register  to view this content.

**jaslake** · 12-12-2015, 11:45 AM

Hi Canadian_chickie

Please wrap any Code you post in Code Tags.

Try this

Please Login or Register  to view this content.

**canadian_chickie** · 12-14-2015, 11:15 AM

Whoops, sorry. Corrected.
That did the trick. Thank you SO much for your help!

**jaslake** · 12-14-2015, 01:05 PM

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

Select and Print Tables based on ListBox Selections

LinkBack

Thread Tools

Rate This Thread

Display

Select and Print Tables based on ListBox Selections

Re: Select and Print Tables based on ListBox Selections

Re: Select and Print Tables based on ListBox Selections

Re: Select and Print Tables based on ListBox Selections

Re: Select and Print Tables based on ListBox Selections

Re: Select and Print Tables based on ListBox Selections

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Select Listbox entry based on another Listbox

[SOLVED] Select Range based on COmboBox selections

[SOLVED] filter based on listbox selections

filter spreadsheet based on listbox selections

How can I select multiple selections of pages for one print job

userform listbox that lists data based on radio button selections

Hide Rows Based on ListBox Selections

Select Multiple Tables With Listbox

Bookmarks

Bookmarks

Posting Permissions