combo box

  1. brendalpzm

    Populate an ActiveX combo box according to a List Box values

    I have a ListBox that is filtered by a TextBox, but I want it ot be filter by a ComboBox as well, This means that If the TextBox is filtering specific values, the values shown in the ListBox must be shown in the ComboBox. This is a visual example of it And this is the code that I'm using for...
  2. B

    Populating a worksheet based on a Combo Box value within a User Form

    Hello I created a User Form that requires the client to complete. The client enters/selects information in various text boxes and combo boxes, selects SAVE at the end of the form and the info is copied in a specific Worksheet entitled Staffing-Processes. The Value in Combo Box entitled...
  3. B

    Listbox Filter using a combobox

    Hi im, currently making a userform that filters all data based off of a combobox value which works but only pulls 1 row of data instead of all rows with the same cell value I.E Column A. I'm trying to have it search for the combobox criteria in Column A and display all rows with the same cell...
  4. S

    Vba code help, userform combobox input selection to specific cell.

    Hello, I have a excel workbook that I have created that needs a specific code for userform combobox. The question/ problem, the combobox has a selection which is automatically populated in the initialization. In combobox the selection is: 1. clamp install 2. damaged clamp With that...
  5. M

    Date combo boxes

    HI Sorry about these questions they seem difficult when i am trying to figure the code out I want to have a date box on a userform. I have previously had a text box which was fine until October (the formatting then failed) this time i want to use 3 combo boxes (date month and year) how would...
  6. R

    Change table data based on multiple dependent drop-down selections

    Hi, I have a data table of financial securities, each item(row) corresponding to a certain country/region of issuance. I would like to have that table filtered automatically to show only those securities issued from a specific country and region selected from a dependent drop-down list...
  7. F

    Combine formula with Combo Box

    Greetings, Does anyone know how I would connect the Combo Box to this formula SUM(--(LEN(UNIQUE(FILTER(B4:B12,C4:C12=I3,"")))>0)) or maybe use another formula?
  8. brendalpzm

    How to change EMBED name of an ActiveX Combo Box?

    Hello everyone, I inserted several ActiveX combo boxes in a sheet, I figured out a way to reset those combo boxes with a macro button, the thing is that I thought I was only reseting one but instead I was reseting them all (which I don't want) I checked what was I doing wrong and in the code...
  9. brendalpzm

    Clear combo box when changing option button

    Hello~ I have form controls option buttons that are linked to an activex combo box, Depending on the option button the activex combo box changes its values. The issue is that when I select a value from the combo box and want to change the option button (this can happen when the user makes a...
  10. brendalpzm

    Change activeX combo box values depending on cell value

    Hello everyone~ I have a problem with a task that I'm not sure how to do it. I have an excel file where I make quotations and it brings a total quotation at the end. According to that quotation result I have an ActiveX combo box that should bring a specific range of values, for example...
  11. brendalpzm

    ActiveX Combo box, Values from dynamic range from another sheet

    Hello everyone, Is there a way to populate an activeX combo box with a dynamic range (this means we can add and remove values) that is located in a different sheet, Also that the combo box is capable of refreshing automatically whenever we add or remove values and ignore blanks. If you could...
  12. A

    Excel form with drop down list

    I've done some research on combo boxes and list boxes and userforms and I feel a little out of my depth at this point as I cannot recreate this form as I need it and I'm sure it's a lot easier than I'm making it out to be. I am not opposed to creating the form in a new method and I would greatly...
  13. K

    hlookup with combobox in userform runtime error.

    Hello, I'm new to VBA. I have written a code that hlookop value in table when I press option button . Sub XS() If UserForm1.ComboBox1.Value = "" Then Worksheets("Sheet1").Range("E1").Value = 0 Else Worksheets("Sheet1").Range("E1").Value =...
  14. S

    How do I link Spin Button to populate a Combo Box?

    Hello, I am new to Excel VBA, so please bear with my explanation. I have a User form with a Multipage setup (3 pages) and on the 1st page, I take the user input for No. of Departments using a Spin Button. Now I want a Combo Box to be populated based on the number selected in the Spin Button...
  15. M

    Filtering data in listbox using two combo boxes

    I have a userform listbox where I want to filter data using two parameters - ALL, Parameter1, Parameter2. With the code that I have written I am only able to filter data using Parameter1 not Parameter2 or All. By default, 'All' is selected which should show all records in the listbox. There are...
  16. N

    VBA help needed

    Hello, I'm trying to make a ComboBox selection text copier. In code i wrote what is the answer of each question if its YES or No selected. Can someone help me how to write a code if there are not all the questions selected but copy only the answered questions text. I dont want to write all...
  17. S

    [MAC] Issue with MatchEntry in userform combobox on MAC

    Hi, I have a userform with a combobox which I built in Windows (Excel 365). The combobox autocompletes nicely in Windows. I have set MatchEntry = 1 - fmMatchEntryComplete. However on the Mac the MatchEntryComplete isn't working correctly. My combobox is linked to a range of cells in a worksheet...
  18. G

    combo box to populate text box vba

    I have the following code. I have a drop down list in my combo box. But when I select a value (text) it does not populate the text box. Private Sub Combobox1_change() Dim i As Long, LastRow As Long, ws As Worksheet Set ws = Sheets("Sheet2") LastRow = ws.Range("A" & Rows.Count).End(xlUp).Row...
  19. D

    Combobox Selection

    Trying to select values from mutable combo boxes. How can I change my code to select values from mutable combo boxes? If Model_Type.Text = "Transit" And WBase.Text = "L3" And Vehicle_Cab_Type.Text = "Single" Then
  20. T

    Refresh Table Data Based On ComboBox

    Hi, Sorry in advance if this doesn't make sense! I am hoping someone can assist, I am currently building a Microsoft Access Database for my workplace to keep track of employees and their movements (e.g. Team Changes). I am trying to create an Employee Details Form like in the Student \ Time...

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