combobox

Hi I'm trying to display data based on a combobox and data in Column D. current code below Sub UserForm_Initialize() Dim lIndex As Long Dim rngMultiColumn As Range Set rngMultiColumn = ThisWorkbook.Worksheets("Sheet3").Range("A4:N100") With Me.AllocateBox1 .ColumnCount = 14...

Hi, Im looking to populate a list box (5 coloums) based on the selection a user makes in a combobox. However, the options in the combobox are not unique, so there will be multiple sets of data to display. Name Age Hair Colour Jack 34 Brown Ben 23 Blonde Steve 45 Grey Jack 65 Black...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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