combo box drop down list

  1. J

    VBA & Combo Box (Form Control) Lock

    I'm trying to create a tracker that my employees must update. Each employee has their own worksheet. The first worksheet is a splash page where they can click their name and it will automatically jump to the worksheet assigned to them. There is also an overall worksheet for their leadership...
  2. P

    Populate Combo Box on Sheet with range of values

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

    Combo Box Typing and Auto Completion in Number

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

    Comman Range with Multiple Combo Box and Not mixed in all combo box

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

    How do I Remove Blanks from a UserForm ComboBox

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

    Creating Combo Box List from a named range that is in a row

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

    How to solve a fill range need in a combo box within a VBA code?

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

    Type mismatch error while filling ComboBox ( Run-time error '-2147352571 (80020005)')

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

    I can't get this dependent multiple combo box menu to work.........

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

    VBA to replace vlookup or countIf due to extensive llist

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

    VBA Form : Add Combobox to Form when number of rows will vary

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

    Date Picker show based on a combobox value

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

    Combo Box & Completing Form with concat additions

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

    How to enter data from userform if table is in the middle of the spreadsheet

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

    Combo box (Active X) / Autocomplete / Data Validation

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

    Reference a Table To Fill Sheet From A Form

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

    Autofill combo-box automaticaly fills 2 more combo-boxes with looked-up value

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

    Arrow Keys on Combo Box (Drop Down)

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

    Define a linked range for combo box in userforms

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

    Active X Combobox Dropdown Issues

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top