combo

On a Form, there is a Combo Box Field which lists different Statuses (e.g. Open, Pending, Closed). Is it possible for the following to happen? When 'Status' is changed from 'Open', add the sentence to the end of the text field 'Comments' to be something like this: "05/05/19 - Closed - J.Smith"...

I have a button which shows a Pop-Up Box asking the user to enter a name of a staff member. Is it possible to edit the Pop-Up so that instead of showing a free text box (where the user can enter anything), it shows a combo box instead which lists the staff names? If it helps, I currently have a...

Hello! I was wondering if someone could help me with the following (please keep in mind that I'm a bit new to VBA): I have a spreadsheet where I want to create one combobox per cell so the user can type in a keyword selection, pick from the drop down, which will return results and auto populate...

Good evening All, I have a form with 2 combo boxes. For the first combo box, combobox1, I have has unique list from Column A as record source using the following code Private Sub UserForm_Initialize() Dim myCollection As Collection Dim cell As Range On Error Resume Next...

I have an Excel sheet that has about 35 combo box form controls (kind of like the drop down boxes). The outputs are all linked to cells in Column B on another sheet that will be hidden from the end user, as well as a cell next to the combo box. (Seems redundant maybe, but we need the information...

Hi. I have a combo box that the user selects their own name. The linked cell to the combo box is a named range. I was hoping to use that named range to apply a filter based on the name to four pivot tables. I was hoping this would do the trick, with the range set to the CurrentPage filter, but...

I have a userform I've developed that has combo boxes that when selected fill a corresponding text box with a vlookup formula. Those work fine but the issue is when you hit the button to submit your entries into the sheet, I get an error because the cycle has started again and with no value in...

Hi - I borrowed this code from ExtendOffice. Unfortunately, it shows multiple combos when in protected mode. There are two lines to toggle on and off protection which is slow and inefficient. How can I display just one instance of the combo without having to toggle protection? Private Sub...

Hi All, I made a searchable ActiveX combo box which works as intended. I also added a button next to it called "Add" which searches a table for whatever value is in the combo box. Once I click the search button, the combo box automatically pulls down the dropdown menu and the only way to...

In the combo Change event I goto my code to do stuff... and the combo box dropdown does not retract. Is there an instruction to make it do that ?

Hello all, I am trying to change the colors on an excel bubble chart based on specific values. I ran across the below video and it's ALMOST exactly what I need. https://www.youtube.com/watch?v=nEOjcyGh1O0 I unfortunately have way more color combos than just the Red, Green, Blue that are in...

Hi! I have a column with over 4,000 data validation lists. All the lists are the same. The problem is, I want my lists to show all 35 items, instead of only 8, so I'm hoping to use combo boxes. Is there any easy way to fill in all 4,000 cells with the same combo box? The other kicker is that...

Hi, I'm currently working on a troubleshooting guide for our team and I've created a userform to be able to search using the 2 combo boxes that are dependent with each other. When clicking the Search button I wanted it to use the information on the 2 combo boxes to find it in a single worksheet...

Is it possible after a new item is selected to NOT have it highlit ?

Hi Guys I have a file where it has various combo boxes with info. I would want a code to send an email with the info in the subject line and in the body of the mail File loaded here http://s000.tinyupload.com/?file_id=43617830343183525506 Regards CT

Hi guys, Can you help me on this. I know this is simple to you. I have a project that i need to simply use a combobox in a userform to select a sheet per categories. For example, if i have a category of Fruits and use the combo box it will have a drop down of mango and will select on that...

I have a worksheet that allows you to transfer a row of a table to another sheet. I do have code that transfers rows based on date but sometimes there is a case where the rows will be required in a monthly sheet that is not of the month recorded on the date. For this case I was going to write...

Hello, I have a workbook that I am setting up as an IO list for a PLC. The main sheet has one combo. The combo box gets it's data indirectly depending on what row/column I have clicked on. If I double click in any cell in column J, the combo box appears in that cell and I can select the data...

Is there anything wrong with the syntax of my for next loop? Sub cmdCopyr() Application.ScreenUpdating = False 'declare variables Dim TableLastRow As Long Dim LastRow As Long Dim TableNumberRows As Long Dim iCounter As Long 'counter of for..next loop Dim...

I have some code where I assign values to variables: 'assign values to variables Combo = Worksheets("Home").Range("Y5") LastRow = Worksheets(Combo).Cells(Rows.Count, "A").End(xlUp).Row + 1 'number of first empty row in column A of Combo...