Increase form control maximum as data increases

[okriskao]

Hi all,

I have followed instructions from this website

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

to create a dynamic chart with dates. I have done everything up till the last instruction. Everything is working very well except that if I set the maximum to 100 (which is higher than the number of rows of data I have now), everything will be messed up and I have to create the chart all over again.

My question is, is there anyway I can set the MAXIMUM control in the scrollbar to the number of rows of data that I have, and also for it to increase as the number of rows of data increases? I hope I have stated my question clearly.

Any help will be greatly appreciated!

[Andy Pope]

The only way to make the maximum property of the control dynamic is with VBA code.