dropdown list

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

Hi all, Currently looking to create athlete programmes and am looking to allow the athletes to select their name from a dropdown box. By clicking on their name, this then will take them to their individual tab/sheet to edit and input data from training sessions. This, theoretically, will save...

Hi there, I would like my drop down list to contain a detailed description of what the user is entering, but only return the numerical value. On Sheet1, I would like dropdown list to appear in Cells F7-F99. On Sheet2, I have my dropdown list information; Column A Column B 1...

Hi, I'm creating a sheet that shows story points per sprint in order to chart it. The table has projects in the first row and sprints for the columns and the data is filtered based on these and dropdown cells. Is there a way to put a wildcard into the dropdown cell that will allow the data to...