dropdown list macros

Hi I created a worksheet with a dropdown for each row of the budget worksheet. The dropdown allows the user to determine if they want to use the recommended monthly budget allocation methodology or manually enter the data by month. Since the worksheet requires you to make this determination for...

I am trying to do dependent drop down in excel vba Range("Q2").Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="=INDIRECT(M2)" .IgnoreBlank = True...

Hi All, I really need your favor today So there's this task on my workplace that i have to do it manually and i don't wanna do it manually. I browsed youtube and landed on WiseOwlTutorials and i found one of the video that taught me how to choose from dropdown area on a website...

Hola a todos! He descargado el siguiente archivo, el cual contiene un listado de articulos. El archivo contiene un Userform el cual despliega una lista dependiente en cuanto el puntero es ubicado en cada una de las casillas (Muy útil) El problema resulta cuando dicha tabla o información de...

Hi all I have downloaded the next file. It has a userform that makes a dropdown list for each column and it filters the results (Which i belive it's very cool) The problem comes when i perform some changes to the database, in where i put some values for the last column, as you can see in the...

Hello All, I am looking for a formula or macro, If I select Yes in "D2", a dop down has to come in "C4", if I again change the D2 to N/A the C4 has to change to "N/A" automatically I have tried with name manager, the problem is when we change the parent cell drop-down list getting updated...

Hi Everyone, I have an Excel Workbook 2016(.xlsm extension) with macros with Multiple Worksheets. I have Dropdowns in many cells with options to select the answer but I am facing issue that Dropdown list is not showing when I send this Excel Workbook to others. Also users are able to enter any...

Hello, My first post, please be nice My coding skills aren't great, but otherwise very well skilled in Excel. Hoping somebody can help, I'm stumped. I have a workbook with tables and charts that are populated from another worksheet (in the same workbook) using lookups. There is a...

Hi Folks, I am working on a spreadsheet to log sales. I have two columns (customers and products) that I've created searchable drop-down lists for (using this method as outlined in youtube videos: https://www.youtube.com/watch?v=vkPoViUhkxU). https://www.youtube.com/watch?v=0QrQT9D25Xk&t=5s...

Hi everyone, I want to build a macro where I have it go to C3 and select next item in the drop down list. For example dropdown list: "1,2,3,4,5,6,7,8,9,10" For example in sheet1 C3, it picks "1" in drop down list, sheet2 C3, it picks "2" in the drop down list.... and so on. How can I do...

All, I am trying to build an extensive spreadsheet, and after a few selections are made, only show the data that pertains to the selections. This is for a Transportation Company and the owner wants to see this. However, he is not computer savy and I may have to show this to him on a paper...

I have a drop-down menu on the sheet called "Start" in cell D7 where a user can choose his/her name. When the user selects his/her name from that menu, I want a hidden sheet to appear after he/she types the password (the sheet holds personal information of the user). The password is checked...

Greetings all, I was hoping someone could offer their input and/or guide me in the right direction for an experimental data validation macro which could (potentially) either automate or streamline data input for my engagement team. In essence, I created a data validation scheme which seeks to...

hi I'm using a macro (below) to allow a user to select more than one value within a dropdown list, HOWEVER, i want it to apply to only ONE dropdown list/cell, and not every dropdown list/cell in the worksheet. I've tried multiple ways of exiting the macro, when not in that ONE cell, but none...

I have a userform with 3 dropdowns. The first is Dept. Name, the second is products, the 3rd is completed products. The user chooses a dept and then a product and is directed to the worksheet for that product and determines some pricing levels. When the user clicks the "accept" button on the...

Hi Guys, I need your help in changing the value from another value: Let me explain the scenerio here: Over here i have a listbox where i am selecting the values into the cell B2, so for example if I select "India" in B2 so on C2(which is drop down of (Goood/Bad/NA)) will automatically pop up...

K. Pretty new to all of this - - all of what I have so far is from researching online but I'm still coming across a problem..... Goal is to have a macro run based on a selection that is made from a drop down list. My list will consist of 6 different macros that I would like to run OR what...