+ Reply to Thread
Results 1 to 4 of 4

AutoUpdate Picklist

Hybrid View

swalsh^s96 AutoUpdate Picklist 04-13-2015, 12:44 PM
Nisha Dhawan Re: AutoUpdate Picklist 04-13-2015, 01:38 PM
swalsh^s96 Re: AutoUpdate Picklist 04-13-2015, 01:42 PM
swalsh^s96 Re: AutoUpdate Picklist 04-14-2015, 02:44 PM
  1. #1
    Registered User
    Join Date
    04-13-2015
    Location
    London, ON
    MS-Off Ver
    Office 2010
    Posts
    64

    AutoUpdate Picklist

    I'm not certain if I need VBA code for this. 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
    Valued Forum Contributor
    Join Date
    05-07-2014
    Location
    India
    MS-Off Ver
    MS Office 365
    Posts
    313

    Re: AutoUpdate Picklist

    Hi Swalsh,

    You can create dynamic list to update the list automatically. To learn how you can create dynamic list please find the attached docx file.
    Thanks
    Nisha Dhawan


    If you like my answer please click on * Add Reputation
    "If you can dream it, You can do it "

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

    Wink Re: AutoUpdate Picklist

    Thanks I will try it out!

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

    Re: AutoUpdate Picklist

    What I'd like is to be able to click in cell A3 and it populate the next number in sequence so it be 5256, and same for B3, and C3.

    ScreenHunter_04 Apr. 14 14.41.jpg

    What you provided I will find useful but not for this application.

+ 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. Picklist that auto updates?
    By swalsh^s96 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2015, 03:04 PM
  2. Using A Picklist and searching for data
    By brad_x81 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2014, 07:39 AM
  3. Driving the sort function from a picklist
    By tgolsby in forum Excel General
    Replies: 0
    Last Post: 06-14-2012, 10:48 PM
  4. Excel 2007 : How to Lock Down a Picklist
    By lgrigor in forum Excel General
    Replies: 3
    Last Post: 05-18-2012, 08:28 AM
  5. [SOLVED] validate data from list without picklist
    By Tara Keane in forum Excel General
    Replies: 1
    Last Post: 01-27-2005, 12:06 PM

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