combo box

  1. X

    Populate multiple comboboxes with the same listfillrange

    So i have multiple comboboxes in a worksheet. Is there a way i can fill all of them with the same listfillrange? The code for that for one combobox would be: Private Sub ComboBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Set col =...
  2. P

    Using named range as list for an ActiveX combo box.

    My Set Up I use Microsoft Office Standard 2013. I have a Table that self populates and formats itself dependant on value selected using an ActiveX Combo Box. I use a Named Range as the list for that ActiveX ComboBox. My issue - making any change...
  3. P

    ActiveX Combo Box drop down button - inside/behind!

    The image shows an ActiveX Combo Box On clickin the drop down the button does not present the linked list, instead it presents another drop down button inside the list area which when clicked presents the list required. Not all persons in my team have the issue. Changeing the combo box...
  4. A

    ComboBox not displaying added values

    Hello, I have a sheet with time stamp values in column B. They are formatted as DD/MM/YYYY HH:MM:SS. I am trying to make a combobox to use as a menu to select a MM/YYYY for further calculations. My issue is: I have 2 subs, one to make the combobox: Sub make_box() Dim pos As Range Set pos =...
  5. D

    Can`t make my combo box fill in with only filtered values and unique values

    Afternoon all Much value any help on this This code below shows only 1 value returned there are 24 plus values it should return?? Private Sub UserForm_Initialize() Dim ws As Worksheet Dim i As Long, Lastrow As Long, x As Long With Me.WBase Set ws = ThisWorkbook.Worksheets("Quote...
  6. dss28

    Copy data from userform to a sheet multiple times as per combobox value

    i have a userform in which i want to copy textbox1, 2, 3 data multiple times as per the combobox1 values to sheet1 as follows: combobox1 value = 1 - copy textbox1 values in cell C3 , copy textbox2 values in cell C4 , copy textbox3 values in cell C5 combobox1 value = 2 - copy textbox1 values...
  7. A

    How can I filter a pivot table with two combo boxes and subsequently open the corresponding PDF file?

    Hello everyone, I'm working on a dashboard on Excel 365, in which I would like to learn how to add two combo boxes which should filter a Pivot Table, named "Notes" and placed in a Sheet also named "Notes"... Basically, this pivot table shows the name of the products, their respective operations...
  8. G

    Type mismatch error while filling ComboBox ( Run-time error '-2147352571 (80020005)')

    Hi, I have a userform that needs to output the names of suppliers ("Fornecedores") and banks ("Banco") from a table in the respective combo boxes, FornecedorBox and BancoBox. For that I used the following loop and it has been working perfectly until I migrated the file from my personal computer...
  9. J

    Array combobox list display, showing the value you are introducing always in the top and see the subsequent values below

    Hello everybody, I'm trying to figure out how to change the display options of a combobox list. As it is now, the actual combobox list goes to the bottom when starts to match with an existing value while you are in the process to introduce a new value. In this example I start to introduce the...
  10. D

    using 3 combo box outputs to find a matching row and display data

    i have a work sheet that im trying to build a user for in, that will take the information selected in 3 different combo boxes and use it to find a row that matches that information and then display the information it the columns to the right of it. i can make it return the information im...
  11. A

    Return values from three combo box's

    Hello All, I am trying to return multiple values based on information in three combo box's. When I run the code I only get the values returned on the first two combo boxes as it looks for the first model which fits two critera but doesn't pick up the third? Any help would be greatly...
  12. J

    Image scale to fit on userform

    Hi, I have a large area on my userform which I want an image to occupy. The image which is inserted is based on a CB selection. However, when the image is inserted, its always much smaller than the pre-determined area. I know I can scale the image area to fit the smaller image, but is there a...
  13. J

    Display graph/chart in userform based on Combobox selections

    Hi all, So, I have a serform (U1), which has two combo boxes (CB1 and CB2). I would like the user to be able to make a selection from each combo box and this to plot a graph. The Y-axis values of both comboboxes is the same. I have a work sheet (see pic), with the number of fruit sales on...
  14. A

    Create Dependent Lists with Auto-Refresh/Update

    Hi All, I want to create many dependent drop list (more than 100) that auto refresh when the source list changes. I am able to auto update the list using data validation and by changing the source list using named ranges but the selected item doesn't change unless I re-select the data...
  15. J

    Using Listbox to alter data in the worksheet

    Good Afternoon everyone. I have a worksheet that monitors peoples favorite snacks, see image. I have a combobox1 in a userform which displays a list of all names. When the user selects a name, the preferred choice of snacks appear in the listbox on the userform. Combobox2 has a list of all...
  16. J

    VBA Combobox options to be filtered by three other comboboxes

    Hi All, I have spent a few days searching / trying to make this work, but its just not working. This is the first time I have posted, so I hope this makes sense. I have four comboboxes in a userform. The first one looks through "Column A" and lists all individual items. Combobox2 lists values...
  17. O

    Populating a combo box based on the options of two other combo boxes

    Hi all, Sorry if this is confusing at all but I could do with some help. Drawing Type Type Drawing Number - E - Exist -E301 'Electrical proposed drawing - M - Prop -M101...
  18. S

    Combo box - only include column headers with certain data type

    Hello all! I have a form with various combo boxes that users can select. Currently I'm populating each combo box with every column header in my data set (not my data set is variable). Here's the code I'm using: For i = 1 To Application.WorksheetFunction.CountA(sh.Range("1:1"))...
  19. C

    ActiveX ComboBox Default Value changeable

    Hi, I've been struggling with this problem for awhile. I've made a form out of ActiveX controls, vba codes etc. I am almost zero knowledge about vba. I've made a combo box, named cmbDate. ListFillRange of the combo box is Q11:Q13, where there are formulas in this cells: Q11...
  20. M

    Print all items in a combo box

    Hi, I have a combo box in cell B2 with a list of names. Is there a Vba code to loop through the list, update the sheet from the combo box and print the worksheet. I have over 100 names in the list and would like to run though the list updating the sheets and printing all. Thanks

Watch MrExcel Video

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