+ Reply to Thread
Results 1 to 4 of 4

Drop Down Box and Printing Associated Regional Forms

  1. #1
    Registered User
    Join Date
    06-27-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    11

    Drop Down Box and Printing Associated Regional Forms

    Hi All,

    I have a dropdown box which selects a store (90+), which displays data tables and graphs based on which store is selected. The stores are assigned to 5 Regional Managers and they have to scroll through the list to select their sites to printi each store details (approximately 20 sites each and an 8 page document). I am looking at a macro button for them to click to get all of their site details printed. Playing around with 2 stores, I have come up with the following, but it prints out 2 versions of the same store. I am needing something in the middle to allow me to assign the right stores to each regional manager.


    Please Login or Register  to view this content.
    'something is needed in here to allow each of the regional managers stores to be printed one after one with the click of a button

    Please Login or Register  to view this content.

    The way they get there data at the moment is in a PDF Format, but even when recording the macro, selecting site, clicking on the PDF button, nothing happens.

    Please Login or Register  to view this content.
    Can anyone help?

    Regards,
    DSL1970
    Last edited by DSL1970; 10-23-2013 at 09:58 PM. Reason: Using # function per Moderator

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,755

    Re: Drop Down Box and Printing Associated Regional Forms

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    06-27-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Drop Down Box and Printing Associated Regional Forms

    Does this meet your requirement - It doesn't seem to have changed......

    If it doesn't please explain more....

  4. #4
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,755

    Re: Drop Down Box and Printing Associated Regional Forms

    You need to click on edit the post. Highlight the code. Click on the # sign in the menu.

+ 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. Printing on preprinted forms
    By cookiegal in forum Excel General
    Replies: 2
    Last Post: 07-25-2012, 05:07 AM
  2. macro for printing filled out forms
    By asdf_random in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2009, 08:57 PM
  3. Printing Forms
    By alexbutterfield in forum Excel General
    Replies: 3
    Last Post: 04-24-2007, 05:08 PM
  4. [SOLVED] printing pre-printed forms
    By Osvaldo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2005, 07:05 PM
  5. Autonumber in Forms while printing
    By Alice in forum Excel General
    Replies: 1
    Last Post: 04-15-2005, 07:06 AM

Tags for this Thread

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