1. O

    ComboBox List Bug

    I built a userfrom to track what we call 'Take 30's' with our employees. I have several combobox's but one of them has issues about half the time. The employee combobox rowsource is referencing a named range which changes based on the value selected in the manager box. Essentially, when the...
  2. C

    Vlookup combo box value to populate textbox

    Hi everyone! Newbie here, I have a small Userform with a couple of textboxes and one combobox. The combo box is populated from a sheet named "Nombres" ComboBox1.List = Sheets("Nombres").Range("A1:A130").Value So what I need is that, after the User select or change something in the...
  3. C

    UserForm with combobox and listbox depending on this

    Hi everyone! I created a userform with a combobox and a listbox. The idea is to choose from the combobox, and depending on the choice, to choose from a specific list in the listbox and use that value later on. So what i have done so far, is the following event with Combobox change: Private...
  4. J

    VBA code to allow changes to existing worksheet data

    Morning all, I hop I explain this well enough. I have a worksheet that monitors peoples favourite 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...
  5. D

    Is it possible to populate a combo box with a range or values that exists 1 row and not a column?

    I have a dynamic range that all the info in is 1 row and I want to use it to populate a combo box but I can only get the value in the first cell to show in the combo box. Range named adbk is on a tab named Admin and the data starts in b1 and stretches out on row 1 below is the line of code that...
  6. P

    Combox is slow and floats in other sheets

    Hi, I used a combox that fills as you type in a project with a long list. I used this option instead of the regular dropbox, because at time we have more than 1000 options to choose from, and it easier for the user to start typing and selecting. The only issue I am having with the combox, is...
  7. N

    Removing an item in ComboBox list if already selected in the other Combobox

    I have 2 ComboBoxes. Both have same items inside. What I want to do is when say if "Report1" is selected in ComboBox1, ComboBox2 should not show "Report1" in the list and vice versa. Thanks. So far I only have this: Private Sub Workbook_Open() Worksheets("Settings").ComboBox1.Value =...
  8. N

    Show different value in ComboBox from selected list

    I have a ComboBox (Quart1) in a userform with the ff list of items added at Userform Initialize: Private Sub UserForm_Initialize() With Quart1 .AddItem "Q1 (Jan to Mar)" .AddItem "Q2 (Apr to Jun)" .AddItem "Q3 (Jul to Sep)" .AddItem "Q4 (Oct to...
  9. D

    Initialize a UserForm with custom name

    Hi, I need to create a UserForm containing a ComboBox initialized with two pre-defined values. The UserForm code looks like this: Private Sub UserForm_Initialize() ComboBox1.AddItem "Value_A" ComboBox1.AddItem "Value_B" End Sub If I run the code, the results are as expected ONLY if the...
  10. S

    ComboBox selected record’s all columns visible?

    Hi all, After DropButton Clicking, it shows all CoboBox’s records with columns visible, but after selecting a record from list, CoboBox shows first column’s value only, rest columns are hidden. Is there a way to show selected record’s all columns? Thank you in advance
  11. Y

    Sort out data using autofilter

    Hi experts. I currently have the following code (see below) in a worksheet I use at work. I would like to streamline the process to filter data by removing the command button to show all data and include "all" in the combobox. When "all" is selected in the combobox it should filter/show all...
  12. M

    ComboBox List Selection Issue

    Hi I have a very annoying issue that i can;t get my head around, I have a ComboBox change event that refreshes a list as its typed and reduces the options in the drop down list. Works fine BUT Once I have selected a item from the list, running any other code/macros elsewhere in the document...
  13. A

    add anew row whan fill data from userform to sheet

    hello i have userform contains combobox1,2,3 and textbox1,2,3 the sheets contains 6 columns a,b,c,d,e,f i would code to add data from userform to the next row in sheet1 the combobox 1,2,3 linked with range from a20:c20 and textbox1,2,3 linked with ranges from d20:f20 every time i fill data in...
  14. A

    transfer data from userform to sheet

    hi guys i have userform contains 35 textbox and 18 combobox i would transfer data to sheet i try make the code but it gives me error this line <tbody> </tbody> <tbody> .Cells(Lastrow, i).Value = Me.Controls("TextBox" & "combobox" & i) the error message could not find the specified object...
  15. A

    Populating combobox with named range, but only one item in range

    I'm using the following for populating a combobox list me.mn2.list = range("MFG2").value This usually works, but sometimes there are cases where that named range only has one value in it. VBA is giving me an error with this. "Run-time error 381: could not set the list property. invalid...
  16. K

    ComboBox BackColor change on value

    I have a ComboBox that I am trying to get the BackColor to change based on a selection. There are 11 ComboBoxes on the sheet. After I have gone through all the boxes and made the selections I hit the finish button which runs the VBA code. Using ActiveX ComboBox. This is the code I tried using...
  17. A

    userform combobox - autocomplete with drop down box

    has anybody got a snippet of code to make a combobox auto complete? as the user types in a name into the cbo, i would like them to be able to select from a list that drops down below the combobox.
  18. T

    How to create selection dependant comboboxs and define data source

    Hello, A forum contributer helped me create a dynamic array for 2 comboboxs which works great. Now I would like to understand how to either create a third combobox or set of third comboboxs based on the selection in box 2? Presently the first row of all columns is the title with the data below...
  19. I

    Hide combobox entry options please

    Evening, I wish to hide two entries in a combobox. Please can you advise what options are available. The two entries in question must be in the combobox BUT not shown. Deleting these two entries isnt an option
  20. P

    Find and select cell to match value from combobox

    Hello folks Stumped again.... :( I want to find and select a cell via VBA based on a text value picked from a userform combobox. The target value will be a text value in a single column which will NOT be sorted and may contain blanks. Is that doable at all? Thanks

Some videos you may like

This Week's Hot Topics