validation list filtering

  1. K

    how to generate a list of names based on two drop down box selections

    I'm really new to <acronym title="visual basic for applications">VBA</acronym> and Excel, I know a few bits and I have created validation lists and a macro to rename the sheetname depending on what text is entered into a certain cell etc. I don't really know where to begin with creating a...
  2. N

    Linked Drop Down Lists

    Hello! I am attempting to create multiple drop down lists where the second box is dependent on the values entered into the first. I know this has been done before, but this may be somewhat unique. Essentially, I want users to select a value from the first list (in this case, teacher name) and...
  3. J

    Data Validation Trouble

    I have created a dynamic data validation list in a worksheet, using nested IF statements and named ranges. The list shows up just fine, however, I am not getting an error when I enter invalid data. I've checked to make sure the error alert is enabled and recreated the data validation a few times...
  4. S

    [ask] auto validation match finder

    i have a very large database of people's name and i have made my own expendable validation without a macro; but i want to make a macro that could pop-up my user forms (this user form is used to show any suggestions when i start typing; i.e. when i type "A" then comes a list of suggestions such...
  5. R

    Progressive filtering of based on typed values in a drop down list in microsoft excel

    Hello all, I have been racking my brain with this problem for the last few days and alas I have been left confounded with this problem and have no solution. I want to create essentially a recipe spreadsheet by where users are limited in their choices that they put in the ingredients box for...

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