combo box

Hello everyone, I would like to create a user entry form that would create multiple rows in the Worksheet in the following way: The user form would have 3 TextBoxes, 2 ComboBoxes, one multiple selection ListBox and a button for the entry An user of this form would write in the random...

Beginner vba user here on Excel 2013. I am creating a user form with two different combo boxes that draw from two different sheets within the same workbook. I have a last row function included for each combo box as the ranges may change from time to time. Here is my code: Sub...

Dear Great Minds of Excel, I'm trying to populate a combo, cbxComboBox, box using row data instead of column data. I have a code that works if I'm on the same worksheet but does not work when on a different worksheet. My userform pulls data from multiple worksheets at once and I would like to...

Hi all! I have made a table that will be used for scheduling purposes, I have combo boxes that will be used to choose the clients name & select a time & have vlook up formulas to enter their information below. My issue is that I would like to replicate my combo boxes all through out the table's...

In Sheet 1, the user would would be choosing the options in the dropdown. I'm not sure whether to use a data validation drop down or a combo box to achieve my goals and how to do it. The items in the dropdown list is located on Sheet 2. The length of the dropdown list will change as new items...

Hi. The question is around a VBA userform: - there are 5 (or more) comboboxes - Combobox 1: Employee Name - Combobox 2:Employee code: Populated based on lookup of value selected in combo box 1(i.e. employee code is tied to employee name and is a unique identifier) - Combo box 3: Department...

I've followed a guide on how to create a searchable combo box, but the change event triggers every time the workbook is changed. Is there a way to prevent the event from triggering when the combo box is not selected or when the user isn't searching?

Hi all, I got a worksheet with many combo boxes they're linked to a cell and what my idea is to provide a prompt if one of the cell within the range contain text which is not allowed. So i got combo box S1-S29 The selection user can click within that combo box is : Kies,1,2,3,4,5 So I tried the...

I have a dropdown Combo box, and figured out how to tab from the combo box to next cell. Now, the last piece of the puzzle to make my file perfect, is that, when I open the file, the cursor will automatically be in the combo box, since it is my first cell. Ideas?? I can attach my file if someone...

I'm very new to VBA and never really used Excel for calculations. That said, I've managed to get some VBA scripting working in a workbook, with the help of a few people from this forum...

Hello Forum, As a newcomer to VBA i would like to request your help on resolving the following issue i have: The first Userform ("lvl2Frm") with a combobox pops up after clicking a commandbutton. The user can select a value in the combobox with source...

Hi all this may not be possible, I have searched threads but can't find my exact problem. I have a pivot table with 'year' and 'name'. I want to then use a selection form for a user to pick a year and name and then the pivot table will only show that data and then go on to run another macro...

Hi, I've tried a number of ways to do this so far, without much success. I have a combo box on a userform. I populate it by put the range in the RowSource of the properties for that combo box. In this case I use EFD, effective dates and they ranges from 02/01/17- 01-01-19 When I choose the...

Dear Experts, Am looking forward to get clarified on a excel vba macros code. Below is my actual requirement, 1. I will have 3 combobox (Which everything is inter dependent --- Combobox2 is dependent on Combobox1, Combobox3 is dependent on Combobox2) 2. I will have a textbox created at the...

I currently have 2 separate comboboxes pointing to separate named lists. I added some vba to create an autocomplete dropdown. The code points to the correct combobox and references the correct list for each combobox. My problem is that when I type in the first one, select a value from the...

Hi, How can you filter a combobox range? I made a registersystem for my sportsclub , i made it that behind the names of the people appear the bill they have to pay I have a combobox , and the range of it is a range of cells in a sheet. now i want that if the bill = 0 the name won't appear in...

I am trying to use an add-in to populate a combo box with an array. There will be 20+ workbooks using this item which is why I want the array in the code. The add-in is working fine for functions, but I cant seem to get the add-in to see the combo box. So far I have not found an answer in the...

I created one combo box in my excel for search my customer name with Khmer Language. While i type Khmer inside they show up with Chinese Verb(as show in picture below). But when i type Khmer outside of ComboBox, it working probably. and i copy it into still ok while the combobox still...

Hello Everyone i have created a userform with two combo box now i have to do something like pattern matching for example if click a value/text in combo box 1 then automatically few value/text should appear in combo box 2. specifically if i click companies in combo box 1 then combo box 2 it...

Group, I've got multiple combo boxes spread out within a single worksheet. These will hide and unhide by section as check boxes are checked and un-checked. I need to ensure these combo boxes remain in their "assigned" locations as the rows hide and unhide with the changes of the check boxes...