.additem

I have a form with a list box and the following code which populates the list With GroupListBox .AddItem "HMP Low Moss" .AddItem "HMP Barlinnie" .AddItem "HMP Greenock" .AddItem "HMP Edinburgh" This only populates the items, it doesn't select an item. I need a piece of code...

So the user has a form which exports to another sheet, I need to put in columns and instead of rows Private Sub ClearButton1_Click() Call UserForm_Initialize End Sub Private Sub CloseButton2_Click() Unload Me End Sub Private Sub Export_Click() Dim emptyRow As Long 'Make Sheet3...

Hello everyone, Is there any possible way to prevent input lag in a combobox? I am currently playing around two combobox and whenever I change the value of combobox1 from Item 1 to Item 2 (vice versa) then select combobox2, I notice that the previous value of combobox1 one goes back to the...

Hi All, Below is my code. After every submit of my record, my user form goes initialize. This makes doubled the items in cmbActivity & cmbTaskStatus.. Any thing on this, which will not double the items in list.. Private Sub UserForm_Initialize() mTimer.TimerOn 10 BtnStart.Enabled = False...

Is there a way to add an item to an active userform by clicking on a label on that userform, which activates a userform to add the item? Yeah, I got a little dizzy explaining that. I have a userform that I have made to add metal drop to our inventory. When we cut a metal sheet down to...

Hello all, I am getting an error when I open a workbook. In a nutshell, for each sheet not named one of the sheets in the code I want to activate that sheet and add the months of the year in the combo box. Each sheet has a combobox1 on it, so I'm not sure why this isn't working. Any help is...

Hi What is the idea behind using "With"? Is it to save time. I am reading this code 'Fill CityListBox With CityListBox .AddItem "San Francisco" .AddItem "Oakland" .AddItem "Richmond" End With +++++ I am thinking, this is the same as CityListBox.AddItem = "San Francisco"...

I am having a problem with a combobox on a worksheet when I select the number 0.10 and it is reflected in cell A1. Cell A3 should show TRUE because cell B1 is greater than A1. What am I doing wrong? I have cell A1 formatted as a number with 2 decimal places and use of the following code ...

I am using VBA in Excel 2010. I was wondering if there is a simple way to check to see if the value entered in the combobox matches the already populated value within the combobox. Private Sub cmbMonth_Enter() With Me.cmbMonth .AddItem "January" .AddItem "February"...

I feel like I have been unable to deliver on my project and that Ive been asking for too much of you all but here I go again. With much appreciation to those who have already helped, this is the code for my userform. Public Sub Workbook_Open() UserForm1.Show End Sub Private Sub...

Trying to get my userform to behave properly. Have two option buttons in frame but I want them to be unavailable unless Checkbox value is true. Based on my research so far, what I have should work but alas it does not. I am still very green with VBA and could use some help. Public Sub...

Our Company has Production Lines A, B, and C. On my userform I have two comboboxes. First Combobox is called cmbSDPFLine and the secondCombobox is called cmbPrdCde. If the user selects "A-Line" under the SDPFLine combobox, PrdCde combobox will only display the products run on that line, and so...

Hello... In a way this is sort of the second half to a topic I posted here: https://www.mrexcel.com/forum/excel-questions/1052587-problem-userform-initialize.html This is an entirely different question though. In my first drop down I have three categories: "Phones" "Monitors" "Computers"...

Hello I have a command button, located on my spreadsheet. The code for the command button is in the vba editor within the name of the sheet - which is sheet114. When the command button is clicked, a userform pops up. The userform has combo-boxes on it. The userform is failing to initialize...

I want to filter combobox1 to display 1 item from my list, but it does not work. I tried to put condition on worksheet, but still not working. Public Sub Worksheet_Initialize() With ComboBox1 If OptionButton2.Enabled = True Then .Clear .AddItem "All"...

Hi Guys, I hope you’ll be able to assist me with the below code. I’m trying to build 4 d active dependent Combo Boxes. I got great assistance from one of the forum members here. However, I’m afraid the code works perfectly till “Case 3000”, starting from this case, it doesn’t work...

Good Morning Fellows, I hope to find the needed assistance here. My project has 3 different Combo Boxes The 1st One is linked in Cell C1 The 1st One is linked in Cell D1 The 1st One is linked in Cell E1 I need to link them to be dependents ones I wrote VBA Code as below Private Sub...

My Combobox lists the customers that are shown in column G (see pics below). Based on the value that is selected, all the rows except those listing that customer(value) are hidden. So... it all works fine, *but* I cant figure out how when the first choice of "Show all Customers" is selected...

Hi, i have the code below and i am only able to add data into one combo box, it wont let me add anything into the other please can you help me, my code is below. thanks again for your time and advice. Private Sub UserForm_Initialize() ComboBox2.Clear With ComboBox2 .AddItem "Data"...

Hi Peeps, I hope someone can help me with my query. I have tried searching on the net but to no avail. What I am trying to do is have "Please type your name here" displayed in the textbox, but when you start typing in something, that disappears. I also need it do display in another box which...