additem

  1. D

    Can`t make my combo box fill in with only filtered values and unique values

    Afternoon all Much value any help on this This code below shows only 1 value returned there are 24 plus values it should return?? Private Sub UserForm_Initialize() Dim ws As Worksheet Dim i As Long, Lastrow As Long, x As Long With Me.WBase Set ws = ThisWorkbook.Worksheets("Quote...
  2. S

    Conditionally AddItem to ComboBox

    Hello, I have a combobox that I'd like to populate with various people's names based on if they pass certain qualifications. So for example: <tbody> Names Run Pass Catch Bob Y N N Jill N Y Y Tony Y Y Y Mary N N Y </tbody> If I would like to populate that combobox with people who can...
  3. F

    Difference between AddItem and RowSource

    Hi everyone! Could someone explain the difference between AddItem and RowSource methods on ComboBox and ListBox form items? Which one it's better to use? Thanks in advance!
  4. M

    ListBox values not changing to specified range

    Hi all, I have a worksheet ("Team1") that lists 19 football players in cells C2:20, each with a command button next to it. I then have a list of formations that the team can play in, in cells DL2:DL34 (this is in a table). Columns DM:EE in this table show the 19 positions that make up the...
  5. A

    Help troubleshooting ListBox additem

    Hi, I've only been working with VBA for three hours so be a little patient. I have a listbox on my worksheet "Main", and I want the options on this to update from a variable list (N3 - N*). This is what I have right now for the code: Private Sub ListBox10_Change() Dim SeamRa As Object Set...
  6. T

    Move item between listboxes

    I am having a very difficult time getting these items to be removed from the original listbox once i transfer them to another. I've tried different things but this is the closest I can get without an error. It involves no removing. Private Sub BTN_NotInGAIT_Click() Dim i...
  7. G

    Not add duplicates in a range to userform combobox.

    After some conditions are true the remaining values in a range get added to a combobox on a userform. It is possible though, that duplicate values get added whenever they both have the same true conditions. How can I make my VBA code ignore the duplicates? this is the code that adds the values...
  8. D

    Can't Get Drop Down List To Populate In User Form

    UserForm Name: "Ncb" Objective: Make use of a drop down list within an an Excel 2007 User Form by populating with the specified item (eg Actual charages, B1, and B2). Private Sub NoPass_Initialize() With Ncb .AddItem "Actual Charges" .AddItem "B1" .AddItem "B2" End With...
  9. MarkCBB

    Add PivotItems into Values box as Averages based on criteria

    Hi there Pivot Table VBA Pros, Looks like my questions are becoming more challenging (I hope) I would like to add Pivot Fields to the value box of a pivot table based on the criteria on the Item on another database. My Master based base has Product infomation (The headings on the database are...
  10. V

    ComboBox AddItem Issue

    Hi, I am creating a dynamic UserForm in which i am creating a ComboBox. I want to populate the ComboBox dropdown with names of the sheets present in the workbook. UserForm is created successfully but ComboBox dropdown is always blank. Here is the code: Set NewComboBox =...
  11. T

    Combobox Question

    Hi all, I have a combobox (active x) on a sheet in excel 2007. What I want it to do is fill it with the Months (Auto, January to December) and also have it run (fill) when the workbook opens. The Auto in the combobox is used to run the reports at the current month and then you can select a month...
  12. D

    UserForm.ListBox Empty Header

    Hi, I have this simple code: With Sheets("Sheet1") For Each Rw In .Range("A2:A" & .Range("A" & Rows.Count).End(xlUp).Row) If ComboBox1.Text = Rw.Value Then ListBox1.AddItem ListBox1.List(i, 0) = Rw.Offset(0, 1).Value...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top