drop down box

  1. O

    Apply VBA Excel Codes to multiple columns for multi-selection drop down menus

    I have successfully used a code to create the multi-selection drop down menus across an entire column but I was wondering there was a way to apply it to multiple columns on the same sheet. I currently have it for E(5) but want to apply it to F(6). I don't have a row limit as we plan the data...
  2. C

    Formula Based on Result of Drop Down Box

    Morning All, I am after a little help with a formula this morning to determine a specific date. On my Spreadsheet In cell E2 there is a dropdown box which contains a number of financial years in the format yyyy/yyyy. The actual data is held on another spreadsheet. What I would like to do is...
  3. S

    Time Stamp with initials from dropdown box value

    Currently I have an Excel file which enters a time stamp depending on if a value is entered in Column A. So it looks like this <tbody> Column A Column B Column C Data<where value="" is="" entered<<="" td=""></where> Blank<blank for="" now=""></blank> A Date Stamp auto fills when something...
  4. F

    How to autofill multiple drop-down lists?

    Hi all, I have a long list (several hundred rows) and I am trying to create drop-down lists that each contain about 5-6 options of my list. I'm sure this can be done with VBA but is this possible to do with basic Excel functions? For instance, drop-down list contains cells A2:A5, drop-down...
  5. C

    hide and unhide rows based the selections in my dropdown list. Please help

    I am hoping someone can help me. I am creating a form in excel using the active x combo drop down option. I am trying to hide rows based on the option they pick. I added the active combo box in cell B3 with options A, B, and C. Based on what they pick I need the following to happen... If...
  6. M

    Variable Drop Down List

    Hello, I am looking to create a variable drop down list that shows the products sold based off of a customer that is selected. For example, if I select customer A, I want the drop down list to show products A, B, C and D that are sold to that customer. However, when I select customer B I only...
  7. A

    Drop down list and data copying to another sheet based on selection.

    Hi every one, I need something that is quite complex and so I'm trying to explain it the best I can, apologies for any ambiguity. So, I'm setting up a tracker for the work done on clients by employees and similarly the work that the employees have done, I need to be able to see both at a...
  8. M

    Format Colour in Drop Down menu?

    Hello there, I'm wondering if Excel's drop down menu allows you to format the color of the options provided in the drop down box. I am essentially trying to make three symbols appear in the drop down: a bold red up arrow, a bold green down arrow, and a bold orange em dash. I have these...
  9. N

    Multiple Selection on a dependent / cascading drop down list

    Hello all, I am trying to put together a sign-off sheet of responsibilities within my organization. To do so, I've created two cascading drop-down lists via Data Validation: Independent Drop-Down: Department within the organization Dependent Drop-Down: Position in the corresponding department...
  10. S

    Drop down list question

    I have 2 drop down lists in A1 and B1, both with a “Yes” or “No” selection. How can I make A1 change to “Yes” automatically if B1 is set to “Yes”? I can’t use macros, only formulas, etc.
  11. C

    Change cell value based on drop down menu

    Hello Everyone, So I created a drop down menu with the days of the week on it. Now I want to be able to alter a cells data to read a time per each day. =IF(K21="Friday","4:00pm") This formula works and hypothetically I should just be able to repeat this a bunch of times but for some reason...
  12. V

    Populate form control Drop Down Box with unique value

    hi, I am trying to populate a drop down box with a column of dates and only want to populate unique values. I have tried the following code but it doesn't work. Can anyone please assist? Sub FilterUniqueData() Dim Lrow As Long, test As New Collection Dim Value As Variant, temp() As...
  13. P

    Replace value picked in dropdown box, from a table data

    Hello! So I am facing a problem with an excel problematic for my work I can't figure out on my own, even after researching a lot online (or when I try them they don't work). I have attacher the file if it helps: https://we.tl/7hopolpjUV. So I would like to replace à value in a cell by a...
  14. S

    VBA drop down / radio button / function to select ....

    So, I am looking for a something simple. I need to call a macro that displays a window with some options that I will pre-define, for me to select. The selection needs to be stored in a variable which I can then use later in the macro for other purposes. The issue I am having is that I can't...
  15. N

    Creating multiple worksheets with data validation based on a single master worksheet

    Hello everyone its been a while since I asked for help but I am trying to create a dynamic list, maybe I should use a table, on one worksheet (something that can grow or shrink in # of rows over time) and have that dynamic list available on several other worksheets in dropdowns so that when an...
  16. C

    Drop down lists and pulling data from worksheet based on drop down selection

    Hello MrExcel community! I am in need of some assistance. I am trying to implement a new staff directory for Special Education staff assigned to schools for the very large school district I am employed by. I have created a data worksheet (Master) with all 180 schools and up to 13 staff...
  17. A

    VBA Help

    I have created a file which is having a drop down list of names vlookup on Sheet1 with another sheet. Hence, one name is selected the values will be displayed on the Sheet1 as vlookup arranged. I need a VBA for that dropdown list having cell (B4), Hence it should be split into multiple...
  18. N

    Excel drop down selections x2 with outcome in third box.

    Hi, I have put together a table with roof pitch (0.5-30 deg) along the top and roof area (5-800m2) down the side, these are my two variables that I would like to select in two separate drop down menus. Based on the selection of roof pitch and roof area selected in these two drop down menus, I...
  19. L

    Worksheet print from a dropdown list

    My problem is coding a drop-down list that selects the worksheet that needs to be printed. The worksheet information to be printed reside in the column "C". In this example, I am showing the dropdown the "vv" selection and I am printing the "sheet1". I see that the formatting is not working in...
  20. E

    Excel: How to create a drop down list that pulls up all the data associated with the selection made?

    I am trying to create a master sheet where all the information associated with each name is entered. It is in a table and each name is repeated in 4 rows and then it goes to the next name and so on. Each name has 4 (1,2,3,4) different ID#'s that indicates the depth where the sample was taken. I...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

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