combobox1

Anyone in user Forfm Private Sub UserForm_Initialize() combobox1.dropstyle = 1-FrmDropButtonStyleArrow 'when UserForm is Intialized or activated the combobox1.value = "" 'or combobox1.text = "" End Sub 1. When clicked on above combobox1 or on the arrowbutton of the combobox1...

Per se.... ComboBox1 is set looking at columns A & B on Sheet1, with a boundColumn = 1; ColumnCount = 2. I am working with the situation where column A can have duplicates, but its corresponding Col-B is a different value. When the user drop-selects Room (Col-A) "119" with Printer (Col-B)...

I created a userform with 10 comboboxes 1 - 10 which populate with part numbers, with corresponding txt_qty boxes 1 - 10 which populate with ordeer quantities. I want to search on the part number in "ComboBox1" and then store the quantity from txt_Qty1 into a cell in the column named "Order...

Hello everyone, I have a combobox called ComboBox1 with is populated by a rowsource. The combobox is on a userform. The issue is that I also have a listbox that populates the ComboBox1 when I click it. Since it (ComboBox1 ) was populated by the rowsource, I get an error when I click it. So I...

Hello All, I have two comboboxes combobox1 and combobox2 and wants to select in the second one as below: when i select the first item in the combobox1, select the first item in the combobox2. When i select second item in cmb1, select the second item in cmb2 and so on. Thanks. Kelly

I have Userform Combobox dropdown which shows date format but when i select the drop down the Combobox value shows general number format why? Otherwise everything is okay. Please suggest! Pedie