combo box

We have a table of invoices with 17 columns in. I have a combo box which populates with the Tenant's company names in and then an invoice number combo box which populates with ONLY the invoices relevant to the tenant selected in the TenantComboBox. However I need the InvoiceNoComboBox to only...

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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