+ Reply to Thread
Results 1 to 7 of 7

Multiple Drop Down

  1. #1
    Registered User
    Join Date
    08-28-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    15

    Multiple Drop Down

    The Multiple drop down option is not working in some of the machines. All the machines are laoded with excel 2007. Can somebody help me to understand what could be the reason for this error?...

    Thanks in advance,
    Tonis

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,326

    Re: Multiple Drop Down

    Hi,

    We need to know a little more. Specifically what you actually mean by a multiple drop down. Is this a cell with data validation, an Activex control, a Forms control or what?

    Better still upload the workbook.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    08-28-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    15

    Re: Multiple Drop Down

    Hi Richard,

    Thanks for message.
    The file is created with data validation.
    What im trying to do is crate a dopdown list and a dependent dropdown list based on the first dropdown list. This is working perfectly in some of the machines. But in some of the machines the dependent dropdown list is not working.

    Kindly let me know if you need any further details.

    Thanks in advance,
    Tonis

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,326

    Re: Multiple Drop Down

    Hi,

    Any chance you could upload the workbook?

  5. #5
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: Multiple Drop Down

    Is this what you are talking about?
    Sheet 1 "SELECT" - If in cell B3 you make your selection, then C3 will only show the parts available for that chosen in B3 (the first Drop-down)

    Anyway, have a look:

    DATA VALIDATION-Lists.xlsx

  6. #6
    Registered User
    Join Date
    08-28-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    15

    Re: Multiple Drop Down

    Hi Richard,

    This is exactly what im looking....Thank you very much...

    I will check the same in other machines and revert.

    Once again thank you...

    Tonis

  7. #7
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: Multiple Drop Down

    Hi tonisjoseph,

    I'll think you'll find I submitted the spreadsheet but whatever that doesn't really matter, just as long as you have the solution you are looking for.

    If you're happy please mark threat as "SOLVED" and if you wouldn't mind click on my "Add Reputation".

    Cheers,

+ 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. Replies: 3
    Last Post: 07-21-2013, 07:20 PM
  2. Replies: 1
    Last Post: 03-19-2013, 07:03 PM
  3. Multiple drop dependant drop downs in single cell
    By LittleJerry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2012, 02:21 PM
  4. Multiple linked drop down lists (Master drop down)
    By zaalibhai in forum Excel General
    Replies: 1
    Last Post: 06-23-2011, 10:51 AM
  5. Dependent Drop Down lists (multiple drop down)
    By jijy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2007, 09:56 AM

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