combo box drop down list

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

Hello everyone, I'm a new comer, very nice to be here. :) I'm totally new to VBA codes and macros (just watched some videos tutorials and online discussions today), and couldn't think of any solutions for what I want to do, so hope some of you could help. I'm using MS Office Excel 2013, and...

Hi All, I am a newbie in VBA and was trying to create a userform that will allow me to track what my people are doing. it compose of parts where data should be inputed. One part is choosing between options in combobox. The chosen option in combobox1 will dictate the list of items available in...

Hello, I picked up a Database from a colleague, and I came across something. There is a form which holds a combo drop down box. To source for this combo box are 2 fields. When I am in the form and select the drop down menu, I see all the values (both columns, which I need) which is...

Hello all! I am looking for some assistance with a combo box. I have created a simple combo box based on a list of 16 cities. My combo box works where I can hit the drop down and toggle between my 16 cities. With that said, I am looking to make my worksheet "interactive" meaning when I...

I have several global arrays of the form: A1Array A2Array etc... And I want to use a Combox dropdown to determine the contents of a second combobox. So the first combobox is populated with: A1 A2 etc... I could use Case statements: Select Case ComboBox1.Value Case "A1" For...

Hi there, I have taken on a project to automate a excel workbook. This worbook has multiple sheets. Each sheet is name the product name. Within that sheet it has the product name, a "Test Type" , a "Test Number", a "Status", and person who has looked at the product. I have created a userform...

So i've gotten my code to work and it works great BUT it's going to be VERY long. At the end I'll have like 80+ Case indexs (I have to copy the code about 80 times and change the range.) Is there a shorter way to do this? I can change the data on the sheet into tables or something and name...

I know the easiest way to do a dependent drop down is with Data Validation. However, the options in my lists are too long to use this (unfortunately, I cannot make them shorter.) I need to be able to create a 2 dependent drop downs (total 3 that cascade depending on the selection.) I was...

I know the easiest way to do a dependent drop down is with Data Validation. However, the options in my lists are too long to use this (unfortunately, I cannot make them shorter.) I need to be able to create a 2 dependent drop downs (total 3 that cascade depending on the selection.) I was...

I am working on a project as a contractor, and I am having a somewhat interesting problem. The company sells chemical products and I was instructed to have one page where the products are listed and can be updated throughout the document. I was also instructed to use type selective drop-down...

hey everyone, I have created a combo down box with 8 names. It works on my computer but when I send to someone else, a + sign appears on the down arrow and will not allow the user to click on the drop down arrow I have had them disable various content blocks but the drop down still does not...

Hi, When i make the merged cells and i selected to have them as the values under Combo box, its considering the empty cells as well. I have merged the cells A12 to A15 as Product A and i merged the cells A16 & A17 and named as Product B. After inserting the combo box from developer tab (Form...

Hello guys,</SPAN> I was wondering: is it possible to link an ActiveX Controls (Combo box) and normal Combo boxes to data in other workbooks? </SPAN> I would prefer to keep the data separated from my “Fill in” workbook (workbook that contains the Combo boxes), because the data will have to be...

Dear Experts, I am struck up here again. I thought some one else may have the same requirement so Im posting here for your help.I am using Excel 2007. I have a user form to create a data base of values. There are 4 combo boxes in my user form. Situation: Let us consider them as Combobox1 to...

I am trying to change the fields in a pivot table based upon a selection from a dropdown or combobox. I recorded the following macro as a start, but don't know how to adjust it to make it dynamic with the selection from the box: Sub OrderType() Sheets("Pivot").Select...

I have searched high and low for an answer to this question and haven't been able to find it yet. Is it possible to change the font size in the Combo Box Drop Down List on Excel 2013? I know it's possible on earlier versions, but I haven't been able to find out how to do it on 2013. Any help...

Hi I am using a combo box to select a value from a table in another worksheet to populate a cell which is working fine. However, I want to use values from this same selection row to populate another two or three cells. Say.... from the drop down list of the combo box I select value G and on...

I have a list of projects in rows B2:B22, below this range at B24:B54 Is a listing a staff personnel assigned to the team. Each person has 4 rows below their name to assign them to a project. I use the validation list method to only choose the projects in rows B2:B22 to populate their...

Hi All! My problem is I cannot copy from a Form Control drop down box, and I need to do this for ~10 drop down boxes in about 200 xls files. The files follow a template so the drop down button Inputs are uniform. Here is some more detail: I’m building an Access Database so that our data...