dropdown menu

  1. V

    Excel: drop down list colouring based on "dependent" list

    I am looking for a solution for my excel sheet and am not finding any on the internet. I have the following data for the dropdown list. I'd like my dropdown list to reflect Column B and the color from Column D according to Column C value that corresponds to the cell from Column B. I seem to not...
  2. D

    VBA to chose format from one column & speed from different column

    Hi there, I have excel sheet data created with VBA, and simple dropdown menu list to chose different formats. But I would like to have an option to select format and then the line speed for selected format would show on cell on top of it. Is there any VBA code that I could use or a simple...
  3. L

    Dynamic Dropdown List Error

    Hi All, First time poster, long time reader. I have been having an issue with a formula I am inputting into the data validation widget to create a dynamic dependant dropdown error. The formula is as follows: =OFFSET(Setup[[#Headers],[Savings]],1,MATCH([@[Expense...
  4. D

    Drop Down Menu Help!

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

    USE IF(AND(...... to check values in dropdown list...

    Hi Can anyone help me on how to use the =IF(AND(.... to check what values that are selected from the dropdown lists and then Return correct cell value? This is my formula: =IF(AND(E4="USD";G4="Free");Cash!E25; IF(AND(E4="USD";G4="Restr.");Cash!E35; IF(AND(4="NOK";G4="Free");Cash!E5...
  6. S

    VBA Help Menu on Excel for Mac

    Hello everyone, I just recently started to use macro recording and basic VBA coding on Mac. For some reason, when I write something in VBA a help menu (picture), which shows me my options does not pop up. Does anyone know how I can activate that? Thanks in advance. -- removed inline image ---
  7. I

    Dropdown Menu That Jumps To Corresponding Row After Selection

    Ok, I just discovered VBA in Excel so take it easy on me guys. I'm trying to create a dropdown menu that is full of dates. I know how to create the menu and use data validation and all that. I would like to know how to enable a scroll function however instead of having to click on the direction...

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