1. E

    VBA drop down changes

    Hi Guys, I have a drop down list from cells B7:D7, which are dependent and the output is generated in cells B9,B12 & D12. I want somehow for the output results cells (B9,B12 & D12) to become blank if any of the drop downs value changes via VBA. is it possible to do that? Thanks!
  2. D

    Sum Range using a drop down menu

    I'm having a problem using the sumif formula with a drop down menu selection. I can easily get the cell value based on the drop down selection however I cannot sum the range of the cells. The Day range would be the drop down containing the last 7 days, the last 15 days, the last 30 days etc...
  3. A

    Create Drop Down Menu of Distinct Dates

    Hello, I have a column containing timestamps. I would like to create a drop down menu in another cell that contains a list of the the distinct month/year combinations in the timestamp column. I know how to copy the distinct values to another column and then create a Validation cell from those...
  4. L

    Force user to enter data on adjacent column if option from list is selected

    Hi all, I have a dropdown list on column AY with 'In-Scope' & 'Removed' as the options. If a user selects 'Removed' I wanted to force them to enter free text in column AZ to explain why they selected 'Removed'. Is there any way to do this? The file is also shared. Many thanks
  5. C

    Searchable drop down list

    HI All, I found some VBA which created a searchable drop-down menu after double-clicking which worked perfectly fine however now when I use it the drop-down appears I then select the entry and then rather than populating the cell it goes totally blank. Please can someone help me. I have no idea...
  6. R

    Dropdown from list in different workbook

    Dear community, In Excel, I am building a small database with information on employees, clients, invoices, etc. I have a separate file with some macros that I use to generate invoices. There are 3 things that I would like to have, where the first is required and the other 2 are nice to have...
  7. D

    Macro to utilize drop-down

    Hi everyone, I have a macro which edits and populates a template (which has other macros in it) and I need to populate a drop-down value for the month. The value is a numerical value of the current month, so I entered a code which would go to the cell "A15" and populate with the numerical value...
  8. A

    drop down filter in Excel

    I'm using a standard filter on a run-of-the-mill spreadsheet. I pressed a shortcut key by accident and now my drop down list has moved to the right, almost as if it's right-aligned. This is just an example to illustrate the position of the drop down box. How do I get it back to normal? Thanks
  9. D

    Dropdown List to automatically enter work shift

    Hi there, I'm new to VBA and Excel. I'm trying to write formula or VBA code to be able to get EXCEL to automatically enter WORK SHIFT based on time when data was selected from dropdown list. I have created dropdown list but now I want EXCEL to enter WORK SHIFT automatically when I select any...
  10. M

    Drop down select

    HI Click on the highlighted value in the drop down and help getting the new window <table class="adjustHtmlDropDownWrapper" width="185" height="17" border="0" cellpadding="0" cellspacing="0"> <tbody><tr> <td valign="top" align="left"> <script type="text/javascript"> var MENU_ITEMS...
  11. F

    Looking for specific data in two columns to put in 2 text options

    Hi all, Explaining situation: i have document with two tabs, one tab has data that will sometimes need yes selected from a drop down on two different columns (BB and BC) and sometime yes won't be picked at all in my other tab i have one column and i want it to look to those two columns and if...
  12. B

    Create blank cells from drop down menu

    Hi All, I'm trying to create a diet plan as i go through the weeks and I would like to stick to one table where if I select the next week, all the cells would go blank and if I switch back to the previous week. I have my data still there. I would like to create a drop down menu of weeks where...
  13. R

    Disable enable drop down based on another drop down

    Hello Everyone, I have three drop down at A1 B1 and C1 A1 has value, Apple, Boy and Cat i want if A1 has apple, B1 drop down enable and C1 should disable if A1 has Boy then B1 = disable and C1 = enable if A1 has cat then B1 and C1 should enable Please help.
  14. B

    Macro To Change Drop Down Company Name and Save as PDF

    Hello All, Trying to work out a process to automatically save chargeback detail for a group of vendors based on a drop down filter. It is based on drop down filter because one vendor can return up to 500 lines. At every change in vendor, save what is visibly showing as a PDF. Sometimes what...
  15. Thumper007

    Formatting on a list Dropdown

    Good Afternoon all, I have a list that contains 3 options. Watch option is a statement. I want to highlight a specific word in each statement and then on another tab, be able to select the statement from a dropdown and have the statement come over with the word still highlighted. Is this possible?
  16. I

    Duplicate data entries from dropdown menus

    Hello, I'm working on a personal project and I have the following problem: I have drop down menus in 13 rows of one column.. These dropdown menus have some overlapping values and some distinct values (on purpose). For example, Row 1 dropdown might have (1, 2, 3, 6, 7), Row 2 (2, 4, 5, 6), Row 3...
  17. M

    Multiple dropdown based on cell value.

    I'm trying to write a macro that with Dependent Multiple dropdown based on Column cell respectively and below mentioned fixed content in sheet2 & in Sheet1 i need the data based on cell value for till nrows. Sample data mentioned below Mname mvalue mtext mid mextn abc 1 xyz q1 po1 abc 2...
  18. P

    Combox is slow and floats in other sheets

    Hi, I used a combox that fills as you type in a project with a long list. I used this option instead of the regular dropbox, because at time we have more than 1000 options to choose from, and it easier for the user to start typing and selecting. The only issue I am having with the combox, is...
  19. D

    Using IF AND and COUNTIF in one formula

    I have 6 dropdowns with the same 30+ options to choose from in each. 10 of those options have similar attributes and I want to advise the user if they pick 4 out of 6 of these when filling in the 6 dropdowns. I have a cell off to the side of these options that will display this message. I got...
  20. S

    Userform Combibox (dropdown) box populating

    Good Morning, I've got a data array, which my userform combibox/dropdown menu references. I have 100 available "slots" for data input in the array, but I don't use all of them. The initialize code (below) works well for the combibox to populate it. However, being as I only use about 20 of...

Watch MrExcel Video

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