validation list

  1. M

    interactive validation lists?

    Is it possible to make two validation lists interact with eachother? Example: A1 = "cat", A2 = "dog", A3 = "bird", A4 = "frog", A5 = "fish" B1 = "Code 14", B2 = "Code 47", B3 = "Code 21", B4 = "Code 34", B5 = "Code 56" Range A1:A5 has been named "the_animals". Range B1:B5 has been named...
  2. T

    Validation list font change

    Is it possible to change the font for a validation list, specifically to change the colour of characters 11 and upwards for the names that appear in the drop down list? I've tried changing the source list cells but it doesn't change what appears in the drop down list. Any help would be most...
  3. boim

    How to set data validation to BLANKs?

    Let's say I have two columns A and B. I'd like to set data validation on B as follows: -If corresponding row in A is some text then show list of valid input. -If corr. row in A is blank then list of valid input is empty. How do I do that? Thank you.
  4. H

    Auto update (extend) Name range

    I have defined a Name called 'Fruit' ranging from cell A1 to A3, say: A1 = Apple A2 = Orange A3 = Banana and i'll use this Name 'Fruit' as data validation (list) on sheet2 (source: =Fruit). If i were to add on A4 = Kiwi, A5 = Peach and so on.. Can the Name range 'Fuit' be extended...
  5. A

    Use cell text as a cell comment of another cell

    Hi there, I have another question that I hope someone can help me with this time. (It appears that my first question was a real stumper! See http://www.mrexcel.com/forum/showthread.php?t=421823) My spreadsheet has a dynamic range dropbox validation in Sheet 1 Col T. What I would like to...
  6. N

    Clickable email validation drop downd List

    Im trying to email directly from my worksheet by scrolling through a drop down list of emails that is in a validation List I set up. I would like to choose the correct email and then click on the cell again whereon it opens a new Outlook email window to the selected email address. I dont want...
  7. Jaafar Tribak

    MouseWheel to Scroll long Cell Validation DopDown Lists ?

    Is there a way ,which i am missing, of scrolling a long validation dropdown list with the mouse wheel ? I am thinking of setting a mouse hook for this (which i guess will be rather involved) but wonder if there is a simpler workround . Regards.
  8. M

    List with no reference to cells

    Hi. I´m trying to create a list from the validation menu but I don´t want to have the items for the list in any cell. Is it possible to create the list without using any cells, (for example, creating a name that stores the list and then using it)? How could I do that if it is possible? I have...
  9. S

    Change Event when leaving a single cell

    I want a macro to run automatically (it changes several cells' validation lists on the basis of the text in the active cell) anytime the active cell is exited and the value in the cell has changed. (I use a validataion list to fill the active cell) I have tried several versions of if statements...
  10. M

    Preventing the same choice being made in two drop-downs

    Hello - I hope someone can advise. I am building a template in Excel and I want an error message (or any message) to appear to the user if they select from a static drop-down the same option in column I as in column J (i.e. they have to pick something different in each case). Issue is I...
  11. T

    IF / THEN Dependency List?

    Help! Reference cell A1 is a dropdown list value selected in A1 needs to influence the display of other dropdown lists in A2 and A3. So if user select "Book" in A1, then the list in A2 will display its list's for additional selections but the list for A3 will not show. If user selects "Car"...

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