combo box drop down list

I would like to have a combo box drop down that would allow a user to select a date from a specified range (which is based on values selected on the "ToolSettings" sheet, specifically the "Select Admissions Term" value) - the combo box is sitting at "Select Test Date" (B10) AB56Select...

Hi, I have coded wages report with ID No selection in combo box. What I expecting is When I typing 1 in combo box, display 1 related numbers and then click tab button related name in textbox. Here these changes happening in scrolling or mouse clicking options only. Can experts guide me to...

Hi, I need experts support. In userform there are 7 combo boxes and each combo box values from Common from Cell A1:A. Cell A1:A Values are Peter Micheal Nick Jump Mary Catherine ..... ..... ..... etc., My question is When I selected 1st combo box value = "Peter" and then all other 6 combo...

I am trying to populate a UserForm ComboBox drop down list and it is also picking up the blanks that are in the column. How do I remove the blanks in the ComboBox on the UserForm. I have not found any code that has worked for this issue.

Some data are in a row. They are renamed. Can the renamed range be converted into a combo box list? For example, names of days namely Sunday, Monday.........Saturday are in a row in place of a column. The range is renamed as 'day'. Can the renamed range be converted into a combo box list? If...

Hello, hope everything is good! I will try to be the most clear with the goal I'm tryin to achieve: I have a Sheet1 where I would like to enter a given record with some information about Country; Transit Type; Incoterm; Forwarder; Currency info. This would be almost what I needed (it...

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

I want to use this combobox menu dependently to access 10 different category menu with its sub-category, item, sub-item etc. The vab code isn't displaying the menus with ID 10, 100, 101 etc, please how do I fix this? I have been on it for a week now, but no luck. PLEASE HELP!!! Option...

Hi, I created comboboxes with dropdown lists I presently have formulas that searches through a long list (7000) of names and then once found information is auto-populated in identified cells This is the search mechanism I presently have in place In Column K...

Hi I have created a user form with a number of textboxes . The Textboxes are pre populated based on an excel data base I would like to add a Combobox with properties of "Yes" or "No" in the drop down list. The number of rows is dependent on an end user selecting their email address and...

Hi, I created a UserForm that requires a datepicker to show based on the value of combobox I tried Sub End_Date () If Me.TxtTenure.value = "Term" Then DTTenure.Show Else DTTenure.Hide End Sub that didn't work and looked through previous posts and couldn't find...

Hi everyone, Super new to writing VBA code. I'm trying to set up a rudimentary document control numbering system. 2 sheets in the workbook, "Doc List" & "Options". I have applied the offset formula for the items under names, and assigned them to names. These are: Author_Name; Discipline...

Hello guys, I am creating a template to log activities and account history and I am unable to add data if my table would start in a cell not at the beginning of the sheet (ex. first column is at C33). The template I am creating will be the same template used for each new sheet generated named...

Hi everybody. I'm having issues with setting up multiple drop-down boxes to auto-complete with a set list of data values. I've got two tabs that have multiple drop-down boxes utilizing the same data values from a third tab. Because some of the drop-downs have multiple selections (Country for...

I made a form with 3 different Combo Boxes, "Age, Gender, Coverage" I want to be able to apply the selected items to a sheet but I only need the value of the table when all three are applied to populate the cell in the sheet. For example: I open the form, select "Male, 18, 250K" click button...

Hello, I want to use autocompletion in a combo-box. I think it's not that hard to accomplish. I already have that code (VBA). Now I want to do the following: I have a sheet (ProductSelection) were I have 3 combo-boxes and a lot of other cells which have to be auto-populated when searching for...

Hey Friends, Hope all are doing well. I just made one drop down by using combo box. I want to select items by using up/down arrow keys. is it possible? please help Regards

Dear Friends I have data on sheet1 cells A2:A8900 and want to link them to combobox 2 in userform (VBA) without replicated and blank cell (cells are updating). How do it? Thanks

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

I am new to VBA and working on a userform but am ready to pull my hair out with something I fear is very simple. I have a combobox (Cntrl2) that I want to populate with manager names. I have a range titled DMNames that I set as my rowsource property for the combobox. This works fine and when...