Dynamic validation lists
Not too much help, but if you show the Formula Auditing toolbar, you'll see an
icon that allows you to circle the cells with invalid data. In code, I get: ActiveSheet.CircleInvalid And you could cycle through the Data|validation cells and look for problems--but what would you change them to? http://groups.google.com/groups?thre...2466%40msn.com Joe wrote: I am using XL 2002 and have a workbook that is used as a template. It isn't saved as a template; it is used as a template for other workbooks. There are several validation lists in the workbook and my client has asked me to create an application or methodology to update these lists while the workbooks are out in the field. Fine - no problem. Here is my question: if I have a validation list that will only allow the values in a cell to be value_1, value_2 and value_3 and, in an updated list the values are listed as value_1, value_2 and value_4, what happens when a user opens a workbook in which there are cells which have the old value of value_3? I know that if they try to type value_3 in the cell, they will generate an error. I am trying to discern which scenarios could be problems and determine possible solutions for them. Any and all help, suggestions, observations and comments will be greatly appreciated. Thank you, -- Joe VBA Automation/VB/C++/Web and DB development -- Dave Peterson |
All times are GMT +1. The time now is 07:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com