+ Reply to Thread
Results 1 to 3 of 3

Add new item to Combo Box Dynamic List

  1. #1
    Registered User
    Join Date
    10-10-2015
    Location
    Brisbane
    MS-Off Ver
    windows 7
    Posts
    4

    Add new item to Combo Box Dynamic List

    Hi Guys,

    I've searched quite a few posts and threads on here but can't quite find what I need. I figured out how to add a combo box to a form and how to populate it from a Dynamic List

    The Combo Box has validation so a name not on the list can't be typed in. What I want is for some sort of message to come up saying "the name is not in the list would you like to add" and then a yes or no option that adds it to the list and for the name to be added to the Dynamic List and then return to the updated combo box but have no idea of the code to actually make all that happen!

    Any help appreciated

    Cheers
    Last edited by Craig2015; 10-11-2015 at 08:04 AM. Reason: Solved

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Add new item to Combo Box Dynamic List

    Basic example of this in the attached.

    I'm sure the code could be tidied up a little and you could add code to alphabetise the name list but I threw this together for demonstration purposes.

    Hope it points you in the right direction.

    BSB

  3. #3
    Registered User
    Join Date
    10-10-2015
    Location
    Brisbane
    MS-Off Ver
    windows 7
    Posts
    4

    Re: Add new item to Combo Box Dynamic List

    Thanks BSB,

    I managed to adjust and it works you are a star!

    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. [SOLVED] Populate userform combo box with named dynamic list
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-28-2014, 05:17 PM
  2. [SOLVED] List in Combo Box, when new item is selected put todays date in the adjacent column
    By Antligen in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-03-2014, 10:30 AM
  3. Dynamic Row / Column change on List Box / Combo
    By vt1 in forum Excel General
    Replies: 7
    Last Post: 05-23-2013, 06:43 AM
  4. Dynamic dropdown list selection based on combo box
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-10-2012, 10:55 AM
  5. Combo box with dynamic list using VBA
    By hsejar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-25-2011, 11:49 AM
  6. Select list item from combo box and add data
    By mli in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2009, 02:08 AM
  7. Assign macro to each item of a drop-down list or combo box - how?
    By jbp20717 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2005, 07:06 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