+ Reply to Thread
Results 1 to 3 of 3

Create ComboBox list from array

  1. #1
    Forum Contributor
    Join Date
    01-18-2013
    Location
    Prague
    MS-Off Ver
    Excel 2013
    Posts
    159

    Create ComboBox list from array

    Hi all,

    I like to create list in Combo Box from the values in column B, if the color of the cell A for the given row is Orange [RGB(255, 192, 0)].
    The values in column B will not be taken in consideration if the color of cell in column A for same row is not orange [RGB(255, 192, 0)].

    The code I've wrote works, just it gives the whole list of values which fits the above criteria. I need to have list in which the values will not be repeated.

    Please Login or Register  to view this content.
    Can anyone help me with this?

    Thank you in advance.

    IgorExcel create ComboBox list from array.xlsb

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Create ComboBox list from array

    Try this...

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    01-18-2013
    Location
    Prague
    MS-Off Ver
    Excel 2013
    Posts
    159

    Re: Create ComboBox list from array

    Hi Alpha Frog,
    it works perfectly.
    Thank you a lot.
    Igor

+ 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] Create ComboBox with list of values from 1 to variable number
    By drrazor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2014, 08:31 AM
  2. Replies: 4
    Last Post: 09-10-2013, 02:11 PM
  3. [SOLVED] Create unique list using Dictionary Object in Combobx 2 based off selection of Combobox 1
    By escobf in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-12-2013, 01:27 PM
  4. [SOLVED] Create combobox .list excluding some columns
    By Hammer_757 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-28-2012, 06:25 PM
  5. Create ComboBox list from Worksheet
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-03-2012, 09:48 AM
  6. ComboBox.list = Array Validation problem
    By D3Pratt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-10-2009, 05:30 PM
  7. Create combobox list from autofiltered range without advance filter.
    By GravityInvert in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-26-2008, 04:22 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