userform combobox

  1. C

    VBA Combobox dependent on another 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...
  2. Y

    Excel VBA userform Combobox eliminate selection

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

    UserForm Object error

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

    Run-time error '13': Type mismatch

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

    Form Automation: Populating a ComboBox during a dynamic userform build

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

    Duplicate declaration in current scope

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

    Filtering with VBA out of user forms.

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

    VBA UserForm Combobox not dropping down

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

    Userform - ComboBox Formatting

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

    Userform - Combobox Question

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

    Userform combobox, allow user to add data

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

    Populate UserForm ComboBox List With Unique Values From Multiple Range

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

    Hide Frame in Userform and SetFocus to ComboBox

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

    Use Named Range to Populate Userform Combobox

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

    Use Named Range to Populate Userform Combobox

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

    Having a Drop Down List in an UserForm

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

    Accessing Userform Variable Values in Module

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

    Lookup part of textstring in Userform ComboBox and search for value in sheet range

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

    Return text in column after selecting an text in Combobox using VBA coding

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

    Using Command Buttons and UserForm Lists in Conjunction

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

Some videos you may like

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