+ Reply to Thread
Results 1 to 7 of 7

Select item from Drop Down list

  1. #1
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    256

    Select item from Drop Down list

    Hi,

    I am working on the case where I need to run the code, which opens the specific file, selects specific sheet, and chooses the item based on cell data from DATA Validation drop down list and closes the workbook without save.


    Is it possible to do with VBA macro?

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,775

    Re: Select item from Drop Down list

    Yes. But hard to give you specifics without sample file and how that selection will be used.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    721

    Re: Select item from Drop Down list

    Is it possible to do with VBA macro?
    Yes, It is possible in VBA Macro.
    share before/After sample dummy file of your data

  4. #4
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    256

    Re: Select item from Drop Down list

    Hi,

    Thanks for the reply.

    Please find attached file with drop down list and SUMIFS based on the selected item from the list.

    So to SUM up:

    The code should work in the following manner: (there are two files: one with list of items to be chosen and 2nd with drop down list)

    1. Look at cell value in the range in the 1st Workbook - "LIST" (sheet1)
    2. Open the 2nd workbook "drop down list" with drop down list and choose the appropriate value from the list based on the value from the 1st workbook.
    3. Then choose other item based on the next value from the range from 1st workbook and so on until the range will end.
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    721

    Re: Select item from Drop Down list

    hi G.Bregvadze,

    Not clear the scenario, what is the input and what will be the output look like??
    what is your current manual process,which you want to automate??

  6. #6
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    256

    Re: Select item from Drop Down list

    Hi,

    The overall process is very complex and I just need the part of this process to be automated, in other words I intend to add this code to the general code.

    for this case I will clarify, as mentioned above:

    1. Macro should be placed in file "LIST" and after running it it should lookup to the list of products on "sheet1"
    2. Open the workbook "Drop down list" and choose first item from the drop down list based on the list at "sheet1"
    3. Save the workbook and leave it opened
    4. Go to the "LIST" workbook, look at the next item in the list, select Workbook "drop Down List" and select item from the drop down menu based on the list

  7. #7
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    256

    Re: Select item from Drop Down list

    Hi there any updates for this case?

+ 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 select next item from drop down list
    By Declamatory in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-21-2017, 03:52 PM
  2. Replies: 3
    Last Post: 07-01-2017, 09:08 AM
  3. how to auto select drop list item when closing file?
    By Imran Magsi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2016, 02:39 AM
  4. Replies: 5
    Last Post: 04-11-2014, 03:13 PM
  5. Select an item from drop down list and auto fill in next working date
    By pjlau in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-23-2012, 12:49 AM
  6. Replies: 3
    Last Post: 11-15-2008, 09:49 PM
  7. Select item in drop-down list in Vbasic
    By ramza in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2006, 05:59 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