+ Reply to Thread
Results 1 to 3 of 3

how to auto select drop list item when closing file?

  1. #1
    Forum Contributor
    Join Date
    02-10-2016
    Location
    Karachi, Pakistan
    MS-Off Ver
    2016
    Posts
    173

    how to auto select drop list item when closing file?

    Hi guys!

    i have created a dashboard in which i have drop list which generate graphs. Different graphs have different numbers of bars now i need a code which will help me when i or anyone is closing file than drop list will auto select a specific item like LS-Karachi.

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: how to auto select drop list item when closing file?

    I dont understand what is the reason behind selecting an item in a drop down on the Close event? will anyone even see that the items been selected? What would happen after the selection of the item?
    If someone has helped you then please add to their Reputation

  3. #3
    Forum Contributor
    Join Date
    02-10-2016
    Location
    Karachi, Pakistan
    MS-Off Ver
    2016
    Posts
    173

    Re: how to auto select drop list item when closing file?

    actually i manually put percentage on bars like LS-Karachi have more bars than others. when anyone selecting another value from drop down list and close/exit from file, after that when we re-open the same file percentage showing on some of bars and again i have to work on it again.

+ 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: 4
    Last Post: 06-16-2015, 12:27 PM
  2. Replies: 5
    Last Post: 04-11-2014, 03:13 PM
  3. 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
  4. [SOLVED] Auto fill line when item is chosen from drop down list.
    By ericabutkovich in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-09-2012, 05:47 PM
  5. Replies: 3
    Last Post: 11-15-2008, 09:49 PM
  6. Auto Select? in Drop Down List Box help
    By Amean1 in forum Excel General
    Replies: 1
    Last Post: 08-27-2006, 11:45 AM
  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