validation list filtering

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

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

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

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

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