userform combobox

Hi all I have a simple userform (CustomerByProduct), where the user must make a selection from the 1st Combobox (cmdProductFamily, with the idea being that this choice then determines the options shown in the 2nd Combobox (cmdProductName). The choice from the 1st relates to a named range of the...

Hi all, Im new to Excel VBA userform and I need you guy's help for following problem. Im currently working to create an excel userform which contain 10 combobox, and I want the user to select item in it but the item will not repeat on the next combobox if been selected from previous combobox...

Hi there, I tried reading a few different threads with similar error messages to try to resolve this, but I'm evidently missing something. I should preface this by saying I'm new to macros and VBA (using various examples and tutorials to Frankenstein my way to something functional). What it...

Hi All I'm back begging for help again. Keep getting run-time error message when i get to the "convert values to a vertical array" part below in Red. Can anybody see where i'm going wrong please. it should be making a list of request numbers for a combobox in a userform so i can update...

Hi, I have 2 workbooks. One is the macro workbook, the other a source list. the macro workbook will be used for storing header data from the source and then later, formatting the source workbook correctly. During the procedure that opens the source workbook, the macro searches for a matching...

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

Good morning, I'm creating a spreadsheet with a userform to filter data. The afflicted portion of the userform is basically just a bunch of comboboxes stacked on top of each other. The combo boxes are populated from several different tables. After the first combobox is selected, I'm hoping to...

Been working on a rather extensive UserForm and all of a sudden when I run it NONE of the ComboBoxes will show the drop down portion when the little triangle is clicked on. I can break on the code and SEE that the ComboBox is populated with values, I can TYPE in the ComboBox and it will change...

Good Morning, Quick question, I want to bold the text of ComboBox1 when I select OptionButton1 but the following code is not working: Sub ComboBox1_format() If OptionButton1 = True Then ComboBox1.Text("Select a NAICS Code") = Bold End Sub How do I fix this? Thanks

Hey all, So I'm made a userform with two comboboxes, let's call them "combobox 1" and "combobox2". I, as a user, can select an option in ONLY ONE OF THE COMBOBOXES. Once that combobox is selected I can then load a chart based on the selection. HOWEVER, I want both comboboxes to work...

Hello Experts I am developing a userform, most of things are done, Only point where i am stuck is: Allowing users to add data in combobox list. Combo box property rowsource is referred to a table "listofservices" There are basically two userforms: Userform 1: which has Combo box (rowsource...

Guys, I was busy with some project and found bits and pieces VBA codes by which I made below code more useful and thought of sharing. Add below code in UserForm_Initialize Private Sub UserForm_Initialize() Dim LastRow1 As Long, LastRow2 As Long Dim Ws1 As Worksheet, Ws2 As Worksheet Dim v1...

I am working on a Userform where the user can select a project name from a ComboBox (which is inside a frame) and if the selected project is one named "New Project" then the Userform unhides a second frame that has a TextBox where the user can enter in the name of a new project. (These two...

Hi All, I've been combing the web and trying to work this out on my own, but I have to admit I need your help. I've created a named dynamic range that I have successfully pulled into a combobox in a worksheet. What I really want to do is use it in a userform combobox in the same workbook. I...

Hi All, I've been combing the web and trying to work this out on my own, but I have to admit I need your help. I've created a named dynamic range that I have successfully pulled into a combobox in a worksheet. What I really want to do is use it in a userform combobox in the same workbook. I...

Hello again! Okay, now I am trying to use a drop down list in a pop-up (UserForm) on my program. The data for the drop down list is located on Sheet1, and the pop-up will occur on Sheet2. I want the data that is chosen on the drop down to populate a column on Sheet2. I have been searching...

Hi All, I have a userform which has two variable and I want to use those variable values in multiple Modules 'Userform Submit Code Private Sub SubmitButton_Click() If Me.ComboBox1.Value = "" Then MsgBox "Please Enter Period Value" ElseIf Me.ComboBox2.Value = "" Then MsgBox "Please Enter...

Hi guys, I have a worksheet with following values: <tbody> A B C 1 Shorts 75 2 Pants 25 3 Socks 34 4 Shirt 10 </tbody> Also I have a Userform with 2 ComboBoxes named "ComboBox1" and "ComboBox2". Values in ComboBox1 is "Pull my pants", "Eat my shorts", "Socks for...

How can I return text on confirmation message box from selecting text from a Combobox linked to adjacent cell in a worksheet using a Userform.

Hi all, I have a macro running in which I am using a UserForm with a dropdown list. The list has three options (pulled from sheet called "Daily"). The operator is required to select one from the list and then continue or cancel. The command button to continue is required to copy the option...