additem

Hi Everyone I have a listbox as such: I want to be able to multiply the Weight (kg) column with my selected rows only by the value in the text box seen above the Qty button. I then want to add those values to the listbox as a new column. I have no idea on how to do this I have tried a few...

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...

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...

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!

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...

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...

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...

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...

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...

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...

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 =...

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...

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...