dependant values

  1. C

    UserForm ListBoxes Dependant Selections

    Hi All, I am creating a couple of listboxes for my users. The first listbox is a list of clients. The second list is a list of projects. I have a separate macro running to copy and paste some data depending on the users' selections. I need to give the users the ability to run either a...
  2. A

    Need help with Data Validation

    The problem i'm facing is that C8, C9, and C10 all have to be positive values and less than C4+C5. That part I've figured out and is fine but the problem is that C9 has to be greater than C10. I set it so C9 has to be between the above restrictions and set C10 so the minimum is C9. The...
  3. M

    Need Help

    Hello! I am trying to come up with a code that does the following things: I have two sheets, sheet "RESUMO" and sheet "Gran.Solos NLT 10491". Each sheet has a cell named "Sample" next to which the sample number is written. In sheet resumo there is a column full of sample numbers, and I need for...
  4. K

    Display different lists based on conditions in a dropdown menu

    Could anyone point me in the right direction, please? I have a list with teamnames for my local poolcompetition. And, thanks for asking, mainly straight and 8-ball ;). Now, I use this list as input for a validation drop down list. Now comes the tricky part: for every team i have a list of...
  5. ClimoC

    Sticky: Display Named Range contents based on text in cell

    Hey Excellers... I have some dynamic named ranges in sheet1, and in sheet2 I have data validation dropdown list which has the names of all the DNR's in it. What I want it to do (in sheet3, no less) is for the user to be able to pick a named range from the dropdown list, and have a particular...

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
Top