combo box

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

Hola a todos! He descargado el siguiente archivo, el cual contiene un listado de articulos. El archivo contiene un Userform el cual despliega una lista dependiente en cuanto el puntero es ubicado en cada una de las casillas (Muy útil) El problema resulta cuando dicha tabla o información de...

Hi all I have downloaded the next file. It has a userform that makes a dropdown list for each column and it filters the results (Which i belive it's very cool) The problem comes when i perform some changes to the database, in where i put some values for the last column, as you can see in the...

I have created a userform with 3 dependent comboboxes and it works well. Can anyone please tell me how I can add another combobox (with items) within the same code, but is independent from the rest of the comboboxes. Here's the code I used. Thank you @DanteAmor for posting the code somewhere...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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