Data Validation comment automatically expand range

[PitchNinja]

Hello, I have a list of names that get updated from time to time when new supervisors start working. The names are listed in a Table that will automatically assimilate any new entries entered below the last entry(Thank you Leila Gharani ). There is also an event code that will automatically sort those new entries within that existing list after they have been entered. My Table starts in cell U8 with the supervisor header and U9 begins the actual list of names. I am looking to make the worksheet a little more user friendly and wondering if it might be possible to have a data validation comment whose cell range will also expand as new names are entered just as the table range auto-expands. So if we had our last supervisor name in U28 for example, our data validation comment range would be from U9:U28. If we add a name to the list and now are at U29, I would want the DV comment range to update from U9:U29. Not sure if this is possible and is a VBA solution or if it would be a non-VBA solution?

[6StringJazzer]

The way that I do this is to just set data validation for the entire column. This does not impact performance, and doesn't significantly add to file size. It is also possible to do this dynamically with VBA but it will have to check every Change event which could affect user experience. Since your table starts with a header in U8 you would set up DV for the column then remove it from U1:U8.

I'm not clear on what you mean by a Data Validation comment. What flavor of data validation are you trying to do in that column?

If this does not seem to address your question then please attach a sample file.

[PitchNinja]

Okay, that might make more sense then to do it that way. I wasn't sure if the file size would be affected or not, but I'm glad to know it's not significant. I'll go ahead with that solution. Also what I meant by the DV comment is just the Input message screen and how it displays a comment to remind the users of something. I think it is very helpful and handy to have that in forms that require maintenance.