combobox

Evening, I wish to hide two entries in a combobox. Please can you advise what options are available. The two entries in question must be in the combobox BUT not shown. Deleting these two entries isnt an option

Hello folks Stumped again.... :( I want to find and select a cell via VBA based on a text value picked from a userform combobox. The target value will be a text value in a single column which will NOT be sorted and may contain blanks. Is that doable at all? Thanks

I'm sure this is something pretty simple for everyone but I'm having the hardest time getting it figured out. I have created a userform that has a combobox. How can I assign a list that the user can pick from when they click on it. The list is on another tab named "Employee Data" and is in...

Hi, I have a sheet that contains several ComboBoxes embedded directly into the sheet. I have them set up so that when I GotFocus the ComboBox dropdown opens (.DropDown method). However, what I would like to do is clear the ComboBoxes and close the ComboBox drop downs when I click on a button...

Hi There, I have no idea where to start with this so would love some help. I have four comboboxes with twelve colours on the list (each has an identical list). Say the colour "Red" is selected in the combobox i want the textbox to populate with information which corresponds to the Value "Red"...

One of my user forms has a list of networks that currently I have hard coded for the drop down list using .AddItem, is there a way to point to a table containing the list to populate the combobox? current code: Private Sub UserForm_Initialize() ' Create dropdown list for Network With...

Hi All Before i get to involved with mu approach. Is this even possible. In a userform i have a combo box linked to a named range in a sheet. 8 options. I then want another combo box that displays a variable named range dependent on the previous combobox for instance combo box 1 has the 8...

hi, reposting and rewording my question to reflect the time zone I am in. I spent about 23 hours trying to figure this out with a sleepless night but to no avail. I have a UserForm and one combobox on it, I need to add only some of the worksheets to the drop down list and be able to switch...

Hello forum, can someone please help with this problem? Objective: To be able to have specific worksheets in the combobox drop down and navigate to desired worksheet by selecting it. Problem: The script I found online links all of my worksheets to the combobox. I cannot figure out how to...

I am using 4 comboxbox's in my excel vba form "Purchase Entry". I would like the form combobox's to pull up records from a dynamic range ProductList sheet and also one combobox should load the other with the matching values. I was bit sucessfull in making my first combobox to pickup unique...

Don't let the title confuse you, this is more complex than you think..... I have a combobox with code: (FYI this code works perfectly No Changes please) Sub UserForm_Initialize() With ComboBox2 .AddItem Worksheets("Sheet3").Range("A17").Value End With End Sub However, Imagine that there are...

Hi all, Imagine I have a combobox from a userform that allows me to navigate through a workbook with many sheets -dozens of dozens- I would like to know why the code of the userform initialize does not add the name of the sheet to the combobox when a new one is created Current code...

Good day all, Please I have a comboBox named "prd" which displays all products listed in sheet1 Column A. Under the comboBox property, I have set the RowSource and also the MatchRequired to True, but the MatchEntry can only be set to MatchEntryComplete or MatchEntryFirstLetter. Please I...

Hi, I currently have a ComboBox drop down on my worksheet which when i click on the drop down i see the list of customers from A-Z in the order of First name then Surname. I need the same but Surname then First name. I have copied the existing code & changed the relevant items but need some...

I would be grateful if there are any suggestions - I have been wrestling with this for several days. I am try to use a UserForm called from VBA to offer a drop down list for user selection. When I create this Userform with a Combobox the box appears but there is nothing in it? So I went for...

Hi everyone, I have a userform that has a textbox1 initialize with today's date(mm/dd/yyyy) and a combobox3 initialize with today's date format(dd). I am using the combobox3 to write to specific rows of the spreadsheet, when they need to make a change to a specific day's data they just change...

Hi All, I am having some difficulty with my code, rare occurrence around here I'm sure :laugh:. I would like to fetch data from a spreadsheet and update the caption of a label based on 3 criteria: 2 ComboBox selections and 1 Textbox entry. Basically, I want to find a value that meets 3 criteria...

Hi all, I have an issue with an ActiveX combobox. In my workbook, an activeX combobox is created each time a cell is clicked. I would like to trigger an event so that when the value of the combobox change, it triggers an event that modify the adjacent one. My problem is that, as you know, the...

I am using a UF that the user enters details on that need to be appended to a range in a worksheet. Once the data has been added and pasted into a holding worksheet, the UF is closed via an Unload commande but when some of the non UF code is executing, the code for some controls are executing...

I have a userform ComboBox that pulls drop down list from Col A of another sheet in workbook. This list in Col A is constantly added to manually. i.e. I have new clients to add. How can I avoid adding new clients manually in order to show up when using the userform ComboBox. What code can I...