dropdown list macros

  1. W

    Macro for worksheet by row

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

    how to do dependent drop down in excel vba

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

    How to choose specific data on a dropdown element with >input element

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

    VBA Listas dependientes con Combo Boxes no acepta valores

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

    VBA Cascading Dependent Drop Down Lists does not accept values

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

    Cell based dropdown list

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

    Excel Dropdown not visible when send to others

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

    Coding help please - Looping through drop down lists and copy/pasting contents into new workbook, saving

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

    Isolating the "=cell("contents") formula to apply only to cells in one column?

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

    VBA select in drop down list

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

    Only Show Data After Selections Are Made

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

    Macro to unhide a sheet based on selection from drop-down menu

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

    Data Validation: Multiple Return Possibilities

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

    xlCellTypeAllValidation (selecting multiple options in only ONE dropdown cell)

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

    Indexing/scripting code issue

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

    How to change values of column automatically

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

    Help with MACROs - - running macro depending on selection made from dropdown list

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top