OK, here is what I am trying to accomplish: I have one cell (M11) that uses a data validation list that is tied to all the names of the worksheets in the workbook. I want the user to be able to select the worksheet they want to use in the first validation list, then have a second validation list update with data from the selected sheet. See the attached sheet for the example of what I have so far. I am getting some errors and need some help. Any help is greatly appreciated! Thanks!
You can't use a UDF to apply Validation - you would need to use the Sheet Object change event based on M11 being altered to in turn amend the validation.
A simpler alternative perhaps...
Delete your UDF call from M12 and apply the following Validation rule to the cell:
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks! That is exactly what I was looking for!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks