Closed Thread
Results 1 to 2 of 2

macro to print through drop down list

  1. #1
    Registered User
    Join Date
    04-30-2019
    Location
    Taiwan
    MS-Off Ver
    2016
    Posts
    6

    macro to print through drop down list

    I'll greatly appreciate it if anyone can help me with this:

    I'm looking to create a macro that will print to PDF from drop down lists and save with discernible file names.

    There are two worksheets within a workbook that has drop down menus: Cpk and Ppk. The drop down menu is a button. A related cell (not sure how it's related) is Cpk cell: R1 and Ppk cell: T2.
    A page per drop-down item needs to be printed to pdf for both worksheets Cpk and Ppk. Worksheets within the same workbook will have the same number of item numbers. A different workbook may have only 3 items.

    Specifically I'd like it to:
    1) Go to Cpk worksheet
    2) select from the drop down menu (eg Item 1-9)
    3) select one of the options from the radio buttons [One sided (Max), One sided(Min) or Two sided spec(bilateral)] --> (eg. One sided (Max))
    4) print from the Cpk worksheet drop down menu to PDF, save it as "Name of the file-Name of the Worksheet-Name of the Spec Value (Cell:A6)-Date (Cell:O4) (eg. 工程能力調查表-Cpk-寬度2-1090206)
    5) select the next item in the drop down menu
    6) select one of the options from the radio buttons [One sided (Max), One sided(Min) or Two sided spec(bilateral)] --> (eg. Two sided spec(bilateral))
    7) print to pdf (for example 工程能力調查表-Cpk-寬度3-1090206)
    8) select the next item until it reaches the last item (# of items could vary from one workbook to another)
    9) Go to Ppk worksheet and perform steps 2-8

    The print range on both worksheet is already set to print one 1 page. All fonts in GREY are outside of print area.

    Please Note: This workbook was not designed by me and I am open to changing the core design of it as long as I can produce the same outcome. I can see the radio button causing unnecessary complexity to the macro. Can the radio buttons be automatically populated the moment an item # is selected from the drop down menu?

    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: macro to print through drop down list

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread:https://www.excelforum.com/commercial-services/1307508-macro-to-print-through-drop-down-list.html

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Print all options from a drop down list as a single print job
    By Sterling1634 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2020, 08:12 PM
  2. [SOLVED] Macro to Print every value from a drop down list with some exclusions
    By RCoin27 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-15-2019, 02:44 PM
  3. [SOLVED] Macro to Print All Options in a Drop Down List
    By lianne.cuscani in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-25-2018, 01:51 PM
  4. [SOLVED] Macro to Print All Options in a Drop Down List
    By Kennylj24 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2016, 11:55 AM
  5. Autoselect from a drop-down list and print (macro)
    By Jejeje in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2014, 02:56 PM
  6. [SOLVED] How can I print a drop down list
    By milkeyway in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 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