I've found several postings around the net on this topic but I'm very new to VBA and haven't been able to take any of the examples and apply it to my situation and make it work.

I have sheet labeled 'DB' with several lists. Each list is referenced to a larger dynamic list on a sheet labeled 'Storage'. I'm using a Forms Scroll Bar for each list to save space but don't want the errors,blanks, or 0s to appear when the master list changes and the number of entries is less than the max value. I also don't want any items to be left out with the number of entries in the master list exceeds the max value.

So I want the max value to linked to a cell that contains a formula which counts the number of entries in the list.

I have attached an example and put the max value formula in the cell below the cell link for each lists scroll bar.

Please let me know how to accomplish this. Thank you!

Example.xlsx