+ Reply to Thread
Results 1 to 3 of 3

Selecting Multiple cells in drop down

  1. #1
    Registered User
    Join Date
    06-28-2018
    Location
    US
    MS-Off Ver
    2016
    Posts
    89

    Question Selecting Multiple cells in drop down

    I was able to get the drop down list to select multiple values but it does it for the whole column and I would only like it to be applied to part of the column. For example I would like it to only be applied to A9:A100 instead of all of column A. Does anyone know how I would do this?

    This is the code I currently have

    Please Login or Register  to view this content.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Selecting Multiple cells in drop down

    Let me suggest this
    Please Login or Register  to view this content.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    06-28-2018
    Location
    US
    MS-Off Ver
    2016
    Posts
    89

    Re: Selecting Multiple cells in drop down

    That worked! Thank you.

+ 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. VBA - selecting multiple choices from HTML drop down list
    By DeanMcK in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2018, 01:26 AM
  2. Want to fill multiple rows and columns by selecting drop down
    By rpcamill in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 05-30-2018, 11:46 AM
  3. Replies: 3
    Last Post: 04-27-2015, 12:16 PM
  4. [SOLVED] Dynamic linking (of 3 cells) while selecting from drop down cell
    By siva venkata in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-17-2014, 07:54 AM
  5. Replies: 2
    Last Post: 06-11-2012, 09:57 AM
  6. Creating a drop-down list & selecting multiple items
    By Jamie6521 in forum Excel General
    Replies: 1
    Last Post: 02-08-2009, 02:53 AM
  7. Selecting multiple items in a drop down list
    By ACM-GFT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-09-2008, 01:59 PM

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