+ Reply to Thread
Results 1 to 2 of 2

Picklist that auto updates?

  1. #1
    Registered User
    Join Date
    04-13-2015
    Location
    London, ON
    MS-Off Ver
    Office 2010
    Posts
    64

    Picklist that auto updates?

    I'd like to create a picklist that auto updates the available items. Want to be able to just have the next number in a sequence be available to select. Could someone help me with some code for this.

  2. #2
    Forum Contributor
    Join Date
    09-30-2013
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2007
    Posts
    229

    Re: Picklist that auto updates?

    If you've created a named range (in this case Dropdown) and the dropdown that refers to that named range
    the following code (a bit inelegant) will do it. You'd have to adjust the location of the drop down.
    Please Login or Register  to view this content.
    If this helped, please click (*) Add Reputation

+ 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. Auto updates not working in Inputs
    By sunplum in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 11-16-2012, 07:57 PM
  2. [SOLVED] Auto Hide Rows based on change in DataVal picklist
    By jstriker in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2012, 10:46 AM
  3. Auto-Updates from a URL
    By Sedapsofeca in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2007, 04:45 AM
  4. invoice that updates # Auto
    By vincew in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-09-2006, 05:04 AM
  5. Auto updates - Clock
    By tom300181 in forum Excel General
    Replies: 0
    Last Post: 08-05-2005, 06:13 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