+ Reply to Thread
Results 1 to 2 of 2

is there anyway to change this code to not allow duplicate values in combobox

  1. 07-13-2015, 03:54 PM #1
    justlearning123
    justlearning123 is offline
    Registered User
    Join Date
    06-24-2015
    Location
    Vermont
    MS-Off Ver
    2010
    Posts
    50

    is there anyway to change this code to not allow duplicate values in combobox 

    Please Login or Register  to view this content.
    Thanks
    Reply With QuoteRegister To Reply
  2. 07-13-2015, 04:19 PM #2
    natefarm
    natefarm is offline
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: is there anyway to change this code to not allow duplicate values in combobox

    If rFind.Column is in sort sequence, then you could put an If within the For loop to only add the combobo2 item if c <> offset(c, 1, 0).
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA code to return values of rows that returns row numbers of duplicate values
    By bharatmvs in forum Excel General
    Replies: 20
    Last Post: 11-27-2014, 02:37 AM
  2. [SOLVED] Combobox unique dropdown from list with duplicate values error
    By Blake 7 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-12-2014, 06:38 AM
  3. Combobox/Listbox Change even to populate values in it
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2013, 06:32 AM
  4. change code of combobox to not duplicate values
    By matwork in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 08-16-2013, 09:16 AM
  5. [SOLVED] Option Buttons to Change ComboBox Values Dynamically
    By Stonesteel15 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-03-2012, 11:48 PM
  6. Code to change LinkedCell of ActiveX ComboBox
    By ozhunter in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2011, 07:10 AM
  7. Create a new chart for every change of values in a combobox
    By uriel78 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-06-2005, 03: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1