dropdown list

Hello everybody! This is my first time posting a thread and I really hope someone here can help me quick enough. I have the following "table" (in quotes bc I couldn't format as an actual Excel table) that brings 3 identical subheaders categories (ADDRESS, EMPLOYEES and EMPLOEMAILS) to each...

Hello. I am in need of some help here. I have 2 drop down lists on my spreadsheet. what I need is so when I select an entry in drop down list #1 for the other drop down list #2 to clear. Vice Versa I also need the same code to clear drop down list #1 when drop down list #2 options is...

Hello Guys, I've been browsing for a while now and can't make it work. I've seen all the steps i need made on different threads but i can't join them due my lack of VBA syntax knowledge. Therefore I'm looking for help in the forum that helped me the most!! I have a user colored dynamic range...

Hi all, I'm in need of a Check Box in Drop down list for multiple selection. The code which i had is given below. The disadvantages of the given code was duplication and unable to edit the selection. Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As...

Hi there, I know very little about VBA, only starting using it this week by copying from Google, so my understanding of it is very small. I've been searching the net for a solution to my problem, however given my lack of understanding of VBA, have not been able to decipher solutions on Google...

I don't know if this is possible but here it is: I have a sheet that I use to display an overview of competitors. The information on the sheet shows one competitor at a time based off of a data validation dropdown list of values. When the dropdown list is changed, the cells on the sheet change...

Hello, I am sure this is a quick fix but for the life me I can't work it out! I am creating a planner with all months going along Row 1. I want to create a drop down so when I select e.g. March it will take me to the month March on my spreadsheet. It is going to be a rather long spreadsheet...

I have set up a drop down list on a sheet using Data Validation. I am now trying to reference the selection that will be made in the drop down on a separate sheet in the same workbook, but when I do so I receive an #VALUE ! error. Note, that if I reference the selection in the drop down on the...

I have a spreadsheet I am working on. I was able to hide used items in the drop down list in column D, but I can't figure out how to carry it over to column H. What would be optimal is: 1) to have the same exact formula/drop down list that is in D:D to be in H21:H23, 2) then to have any...

Greetings, is it possible to have (3) dropdown lists equal a dollar amount? Task at Hand: I will try to simplify to help make sense. Let's use a restaurant menu as an example. Depending on your order and the options chosen, the total will be different. Dropdown list 1: Types of meat-Chicken or...

Hi all, <tbody> Manufacturing line Type1 Type2 PPA New product PPA ELH Basic PPA Old product ELH Advanced ELH </tbody> I am trying to create dependant dropdown lists so that based on Manufacturing line, Type1 and Type2 are possible to be selected. So if I select PPA New product...

Hi, I have a 2 dropdown lists. The second dropdown is (dynamically) populated depending on what is selected in the first (using =INDIRECT). The second dropdown list gets it's source data from 6 columns. The number of rows varies in each column. The first dropdown list gets it's data from...

I'm a VBA beginner and need some help. I have a dropdown menu for A, B, C, D. If option A is being selected, userform will pop up. Otherwise if B, C or D is being selected, nothing will show. Thanks a lot for all your help.

I have 2 sheets on my workbook. Sheet 1 has all the master data. I'm using Sheet 2 to pull data from Sheet 1. Sheet 1 has the date in Column A, that date is converted to month text in Column B and in Column C I have the corresponding data for those dates - in this case a revenue number. On...

Hi, I want a simple drop down list in a vba userform. The list is from sheet 2 a7:a20. I have it where the form will activate but can't figure out the dropdown. Also, if they dont click one I want a form to show that says missing info. I have that made. Its called missing info. Summary userform...

Hello, I've been having trouble with my ActiveX ComboBoxes on my excel spreadsheet. I am not using the ComboBox on a UserForm, it's just on my sheet. Here is the situation: I have a ComboBox whose chosen value will trigger my VBA to either hide or unhide rows which contain other ComboBoxes...

Hi All Been a while but I'm stumped. I have a large list of data with a dropdown list that filters out what I need. Only issue is I would like to group a few options preferable using one list. My Example List Apple Banana Orange Cat Dog Mouse Fruit Animal Trick I would like to know how to...

https://drive.google.com/open?id=1z7JllULnypzq2qdpSXaUZqJhjQjuobXdiVCzOE1vsjY Hello, I'm trying to make a dependent dropdown list in the "Model" section B1, in A1 a drop down has been created and I defined a name on the Formulas tab, create from selection tab. On the data validation, I am...

<colgroup><col span="7"></colgroup><tbody> Model spec colour model 1 a b c white black grey model 2 a d e green white blue model 3 c f g yellow red black </tbody> Is that anyway to create the 2nd(spec) and 3rd(colour) drop down list base on the selection of 1st drop downlist(Model)?

Hello! How can I set a data validation list such that if the drop down value in the cell is deleted, the cell will automatically show a default value (i.e. "-Select-")? For example, I have a worksheet with multiple drop down lists that I want to show a default value of "-Select-" once the...