+ Reply to Thread
Results 1 to 2 of 2

Adding values to a ComboBox (as end-user)

  1. #1
    Registered User
    Join Date
    07-21-2019
    Location
    New Zealand
    MS-Off Ver
    13
    Posts
    4

    Adding values to a ComboBox (as end-user)

    Hi there, I have a Userform that utilises multiple comboboxes in order to tag an event (this data is then transcribed to a table on the spreadsheet dashboard).

    For example, cboControlEnvironment allows you to select the control environment of the record, this is then followed up with a selection from cboSubControlEnvironment where the end-user is expected to select their subcategorisation of the the record.

    This is all and well (IE working) - but I need a contingency in order to cater to currently unknown Sub-Control Environments, and where the end user would be able to free type their subcategorisation and then have this added to the combo drop down.

    My combo boxes are currently populated through the addItem method (as per code below). Any assistance would be greatly appreciated.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Adding values to a ComboBox (as end-user)

    What I would do is create a sheet "Data" and list all of the SubControlEnvironments in one column of that sheet. (column A for this example)

    The you could load the combobox with code like

    Please Login or Register  to view this content.
    The end user could add to that sheet as needed. The sheet could also be hidden.

    And similar forward looking lists could be used for the other comboboxes and their entries.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ 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. Adding Values to a Combobox using Properties
    By cs0rpc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2017, 11:30 AM
  2. Calculating/adding userform textbox values based on combobox selection and display to cell
    By SpreadsheetGirl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2015, 08:57 AM
  3. [SOLVED] Force user to only enter values from dropdown menu in combobox
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-05-2015, 05:15 PM
  4. [SOLVED] userform: when selecting Combobox value force user to choose from second combobox
    By mortphil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-31-2014, 12:29 PM
  5. transferring combobox value from one user form to populate combobox on another
    By smartphreak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2010, 10:12 PM
  6. adding values to a combobox from a specific range of cells
    By blindzero678 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 08-05-2010, 07:02 PM
  7. adding values in user created areas, defining boarders
    By bmccarthy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2010, 10:51 AM

Tags for this Thread

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