Populate Combo Box With Unique Items

Dec 19, 2006

I have a combo box (from the Control Toolbox toolbar). I like this to be populated with the contents of column A. however, in column A there can be duplicates. I obviously don't wan't any duplicates in the combobox.

View 9 Replies


ADVERTISEMENT

Populate Combobox List With ONLY Unique Items ()

Nov 16, 2006

Populate Adv Filter Criteria from Inputbox with valid data

I've set up a macro to extract 3 different sets of data using Advanced Filter (same data range, different criteria & extract ranges)

There are multiple options (different individual dates) to satisfy the criteria (a date) for each of the 3 extracts and I want the user to select the criteria (a specific date) from the range of unique values in the data range upon which the Advanced Filter criteria is going to be applied. (A bit like the effect provided by Autofilter)

My initial attempt was to capture the criteria date from the user and populate a cell, and then have a vlookup function in another cell check if that crieteria value exists in the specified range. I then ran a loop in the VBA code until the value is valid (ie. exists in the range). However, to streamline this I was hoping to allow the user to see a list of the valid (available) dates when they respond to my Inputbox request for the criteria.

View 9 Replies View Related

Print Many Items From Combo Box In One Go

Nov 29, 2009

I have a list of items and I would like to print each of their details without having to select each of them from the combo box and then press the print button for each of them...

Is there a way to do this automatically ?

View 9 Replies View Related

Combo Box Won't Populate

Dec 13, 2012

I have a problem where a combo box in a form won't populate from the VBA code in the initialise routine. I've tried a couple of difference methods for populating the combo box without success. The code I have is:

VB:
Option Explicit
Sub NewTender()
Application.ScreenUpdating = False

[Code].....

I tried the excel file uploaded by Norie but it only displayed "Is". Are there any settings I need to modify to allow the add item property to work?

View 2 Replies View Related

Populate Combo Box

Jun 7, 2006

I have some problem making one Combo Box in excel to be populated by data from a closed workbook.

View 9 Replies View Related

Combobox ADDING Only The Items That Are NOT In The Combo Already

May 2, 2006

I've got a database and want to put the names that are in one culumn of the Worksheet into a combobox.

I use a Loop and the addItem procedure.

The thing is that there are many names that are the same, just diferent records for the same company...

How do i do that every name only appears once in the ComboBox.

View 3 Replies View Related

Combo Box Populate Column

Aug 21, 2007

I have a quick question regarding combo boxes...and I may have to use VBA.

I want to have users select a value i.e. Fish from a down box. Once the user selects fish all instances for fish populate i.e. Trout, Salmon, Tuna, etc. in the adjacent column.

The list of fish can be in the same workbook or a different workbook as well as the value.

View 12 Replies View Related

Filter Values To Populate A Combo Box

Dec 21, 2006

I have a column with company names, with repeats, and I am trying to filter out the repeat entries and fill a combo box with these entries. I also want the box to update every time I add a new company to the list that isn't a repeat of one already on the list.

View 14 Replies View Related

Vba-populate Listbox After Selection From Combo

May 16, 2009

In my workbook i have worksheets that are named 01-Jan-2008,15-jan-2008,30-jan-2008...and i have almost 50 for each year.from 2007 to 2009. I have created a userform where i have a Year combobox with values 2007,2008,2009 and an ok button
then in the same form, i have a listbox and an Ok button and a back button.

i want the user to be able to pick the Year from the combobox. once he specifies the year, the worksheets corresponding to that year should appear in the listbox...instead of populating it with all the 100+ wksheets i want the search narrowed down.

View 2 Replies View Related

Populate A Combo Box With The Filename From A Folder In VBA

Aug 17, 2009

I am trying to populate a combo box with the filename from a given folder, ideally without showing their .xls extension if possible.

View 12 Replies View Related

Populate A Second Combo Box Based Off The First One's Current Value

Oct 13, 2008

I have a list of insurance companies as column headers (B1:U1) and a list of what types of insurance they sell as row headers (A2:A6). Within the table, there is a "O" if they sell that type of insurance, and blank if they do not sell the insurance.

My first combo box is the list of insurance companies. I want my second combo box to be populated with only the types of insurance that particular company sells.

View 9 Replies View Related

Populate Combo From Closed Workbook

May 23, 2006

I have workbook "Invoice" which has one Combobox. This Combobox1 should takes its data from another workbook /closed/ called Firms. I need it to be closed.
What code i should write and where, so that when i add new firm and close the workbook Firms, so that the new value will be added to the combobox1?

View 6 Replies View Related

Creating A Unique List Of Items In Column A That Have A Corresponding Non-zero Value In Column B, I.e. Excluding All Items Where Sumif ColumnB Would Sum To 0

Jul 17, 2009

I know how to use array formulae to create a unique list, i.e.{=INDEX($G$1:$G$760,SMALL(IF(ROW($G$1:$G$760)=MATCH($G$1:$G$760,$G$1:$G$760,0),ROW($G$1:$G$760)),ROW()))}

however this is giving all the unique items from column G and I only want the unique items that have a non-zero value in column H as well. This would be the sumif of all instances that would have to be zero. I've tried to crack it and I've tried to search for solutions but so far no joy.

View 9 Replies View Related

Populate Two Text Boxes Based On A Combo Box Selection

Dec 31, 2009

I want to populate the values of two textboxes that we will call TextBox5 and TextBox6 from columns W and X of a spreadsheet called "PowerAnalysis" when a selection is made form ComboBox5.

The ComboBox5 works perfectly now. I just need it to populate the other two text boxes.

All the data resides in the same row on the same sheet of PowerAnalysis when the selection is made in ComboBox5.

I hope I have been able to give a clear picture of what I am wanting to do.

View 9 Replies View Related

User Form - Select From Combo Box And List Box Should Populate

Jan 18, 2007

I've created a user form (click button on 'main page' to display). Combo Box called 'Last name' gets populated with all second names from the sheet 'Staff'

When a user selects a second name from the drop down list, I would like excel to automatically update the list box 'First Name'. Also, If a user changes the first name or Last Name, this should be saved

View 9 Replies View Related

Unique Values Only In Combo Box

Apr 21, 2006

I have a combo box on a form that is linked to a column of values allowing pre-emptive typing, or selection via a drop down. This works perfectly with one exception - each item shows up multiple times.

Is there any way of getting around this? the only way I can think of offhand would be to link it to a seperate table which is populated on a semi regular basis via another VB process? I would have thought this would have been a fairly common question but haven't been able to find anything on this board or others as yet.

View 3 Replies View Related

Combo Box Dynamic Unique List For Input Range

Sep 30, 2012

I am preparing a template for which I need a combo box. Becaue it is a template I can't have this combo box any specific input range. Because I won't know how long the data column (that wiill be used for input range) will be.

Also the data column will have many duplicates but the combo box needs to show uniques only.

View 1 Replies View Related

Populate Userform With Items From Drop Down

Jul 15, 2008

I would like to populate the captions of checkboxes in a userform with the items listed in a drop down menu located in cell A1. Lets just say I don't know exactly how many items in the dropdown there will be, but I do have an estimate number. Maybe between 20 and 25.

View 9 Replies View Related

Can't Populate Array With Selected Items From Listbox

Mar 16, 2014

I am trying to take selected items from a listbox and put the selected items into an array. Basically I am trying to put the selected items into a variable that I can pass to other modules. I am close but something is off. I can't tell if it's the variable declaration or the code.

I get Run Time error 91. Object variable or with block variable not set

Here's what I have so far...

[Code] ......

View 2 Replies View Related

Add Unique Items

May 7, 2007

I have a code which works perfectly and adds the dates from Column A to UserForm1 ComboBox2.
In column B, I have textdata - UserForm1 ComboBox5.

I'd like to transform the code to add only the dates which correspond (cascading) to 1.1 textdata in ComboBox5 (Column B) and 1.2 dates in ComboBox2 (Column A).

Code: ...

View 9 Replies View Related

Remove Duplicates And Populate Items Based On Dropdown?

Feb 10, 2014

I have an excel sheet with data where I have column A index number, B company name, c empty, d data , e with item.

[Code] ......

What I trying to do is I made a dropdown for company list and i select comp1 then i want to populate items list with out duplicates .

View 2 Replies View Related

Copy Unique Items

Jan 8, 2009

How to make it copy over A, B, and C not just A and B? I tried adjusting some of the ranges, but I get a Run time Error 104. Also, what is the (Rows.Count, 3) doing?

Sub CopyUnique()
Dim LR&, LR2&
Application.ScreenUpdating = False
With Sheets("AY")
.Range("A1:B1").EntireColumn.Insert
LR& = .Cells(Rows.Count, 3).End(xlUp).Row
.Range("C1:D" & LR&).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("A1:B" & LR&), Unique:=True
LR2& = .Cells(Rows.Count, 1).End(xlUp).Row
.Range("A1:B" & LR2&).Copy Sheets("ORG").Range("A1")
Sheets("ORG").Columns("B:B").Columns.AutoFit
.Columns("A:B").Delete Shift:=xlToLeft
Application.CutCopyMode = False
End With
Application.ScreenUpdating = True
End Sub

View 9 Replies View Related

List Unique Items ...

Jun 15, 2009

I have a list of >50 contract numbers listed in cells A1:A350, with several of the numbers listed more than once. What I would like to do is, on a separate worksheet, list each contract number only once, in column A.

View 9 Replies View Related

Count Unique Items

Jun 16, 2009

Counting unique items in column (numbers)

View 9 Replies View Related

Count Condition Unique Items

Jan 22, 2009

Can someone please help me with formulas to calculate the # of Unique Customers, #of Items, and Amount for Q1, Q2, Q3 and Q4 for the year in A2 (which contains a drop-down list).

Please see attached sample workbook. (I can’t figure out how to combine the formulas for count unique items with a specific quarter.)

View 14 Replies View Related

Count Total Items Per Unique ID

Feb 19, 2014

I need a formula to count the total items per unique id. For example

Column A Column B
11111 Basketball
11111 Basketball
11111 Basketball
33333 Baseball
33333 Baseball
22222 Hockey

Output to Column C,
ID 11111=3 Basketball
ID 33333 2 Baseball
ID 22222 1 Hockey

View 11 Replies View Related

Listbox With Unique And Dependent Items - VBA

Sep 25, 2013

I have a Listbox1 in which I was able to populate it with unique items (from column B in Programs worksheet) using a collection (that was a good achievement for me!)

Now, I want to populate a the Listbox2 with items (not repeated) from column C, BUT only if the correspondent value on column B is equal to listbox1.value.

[Code] .....

View 4 Replies View Related

Retrieve Unique Items With 2 Criteria

Nov 29, 2005

I've been using the following formula from the xldynamic website detailing
sumproduct usage as a base for retrieving uniqe instances in a data series.
I've been trying to modify the formula to allow me to utilize one additional
criteria.

Original formula:
=SUMPRODUCT((A1:A20<>"")/COUNTIF(A1:A20,A1:A20&""))

Here is my formula:
=SUMPRODUCT((($O$7:$O$2710<>"")*($M$7:$M$2710="1986"))/COUNTIF($O$7:$O$2710,$O$7:$O$2710&""))

I'm trying to say how many unique instances are there for column O, where
column m = "1986?"

View 10 Replies View Related

Dynamic List Of Unique Items?

Sep 13, 2012

I have a sheet of un-ordered data with duplicates. Looks a little like this:

Sheet2
*
A
B

[Code]....

What I want to do is: on a separate sheet, when the user inputs a Region name, it will return an array of unique Locations under that Region. For example, if the input is "NORTHEAST", the following would be returned:

Sheet3
*
A
B
C

[Code]....

View 7 Replies View Related

Count Unique Items With A Condition?

Oct 30, 2012

I've an excel sheet with 1000 rows data. I need a formula to count number of unique items in a column with a condition. Please find a sample data sheet.

I've tracking list that has ordered and delivered items for a given month on weekliy basis such as Week1(W1), Week2(W2), etc. I need a formula to count number of unique item delivered on this month.

Item 1 to item 8 delivered and item 10 also delivered in week 4, So totally I need to get the result as 9.

I was trying to use "countif" for validating and counting each row, it's throwing value! Error =1/(COUNTIFS(A:A,A2, c2:c23, ""&0)) i.e., = 1/countifs(unique items from column A, then nonblank cells in column C) but it's giving Value error..

I just need to count the unique item with another condition.

Item details
Order week
Delivered Week

Item 1
W1
W1

Item 2
W1
W1

[code]....

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved