Results 1 to 12 of 12

ActiveX ComboBox Duplicating Values

Threaded View

  1. #1
    Registered User
    Join Date
    01-05-2015
    Location
    Wisconsin
    MS-Off Ver
    2013
    Posts
    50

    ActiveX ComboBox Duplicating Values

    Hi!

    I am trying to develop a 2 ComboBox's with the same drop down information, but the "drop-downs" duplicate each time I click on a selection. Do you have any recommendations for how I can fix? Additionally, any suggestions on how to use this ComboBox selection to populate a range of data (additional worksheets within same workbook) to create a comparison of data? Thank you in advance.

    Private Sub ComboBox1_Change()
        'Add list entries to ComboBox1.'
        ComboBox1.AddItem "A"
        ComboBox1.AddItem "B"
        ComboBox1.AddItem "C"
        ComboBox1.AddItem "D"
    
        'Use drop-down list
        ComboBox1.Style = fmStyleDropDownList
    End Sub
    Thanks
    Last edited by ocnmel; 05-23-2022 at 04:16 PM. Reason: Add [CODE] tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Duplicating Values In Combobox Undesired When Navigating
    By jayfin in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-18-2021, 02:01 PM
  2. [SOLVED] ActiveX Combobox in worksheet when populating the list based on another Combobox get error
    By jprlimey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-27-2020, 10:54 AM
  3. [SOLVED] ActiveX Combobox not accepting numeric values
    By drapson in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-04-2018, 01:54 PM
  4. [SOLVED] ComboBox Duplicating Values
    By spacle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2017, 03:13 PM
  5. Dependant Activex ComboBox duplicating the items
    By VBAPAZ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2017, 11:22 AM
  6. ActiveX combobox datalist dependant on previous combobox selections
    By Mrs Poodle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2014, 07:07 AM
  7. [SOLVED] fill listbox (ActiveX) based combobox (ActiveX)
    By elsg in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-31-2014, 11:25 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