+ Reply to Thread
Results 1 to 2 of 2

Printing Multiple Options from a Drop-Down List

  1. #1
    Registered User
    Join Date
    10-08-2014
    Location
    California, USA
    MS-Off Ver
    2010
    Posts
    1

    Unhappy Printing Multiple Options from a Drop-Down List

    Hey everyone, I'm new here.

    I just took over a position in the hospital where part of my duties are printing out monthly patient info in a cute little sheet to give to them. The data for each month is stored on seperate sheets within the workbook (one sheet per month). I have to select the patient's name from a drop-down list in cell B2 on a seperate results sheet (INDI), which updates another sheet (RCARD) that I then print.

    So currently I have to go back and forth between the last two sheets described, clicking the next option on the INDI drop-down box and then going back to RCARD to print, for every single patient.

    I was hoping to find a way to make a macro that would allow me to loop through all the options in the box, selecting them and then printing off the RCARD worksheet for each selection. I've tried modifying several examples that I found online, with no success. Can anyone help, please?

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Printing Multiple Options from a Drop-Down List

    CYCLE THROUGH DV OPTIONS
    Here's a basic macro for cycling through all the Data Validation options in a certain cell. The sample then prints out the workbook, but you can replace that line of code with whatever action you prefer, this should give you the basics.
    Cycle Through Data Validation Options
    Last edited by JBeaucaire; 12-26-2019 at 05:13 PM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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 drop down options on a form - help required
    By adele001 in forum Word Formatting & General
    Replies: 0
    Last Post: 09-10-2013, 06:18 AM
  2. drop down list with options
    By kayye in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-03-2013, 12:06 PM
  3. [SOLVED] Column B drop down list with 2 options, columns C & E with dependent drop down lists
    By betic in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-26-2012, 03:47 PM
  4. Drop down list. I need more options
    By cybercab in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2007, 12:12 PM
  5. My Excel drop-down list eliminates from list options chosen. Help
    By Sybil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2006, 05:25 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