create controls on a form for the value of a named range?

[jinx_uk_98]

Hi all,

I have a named range of cells that is added to and deleted from over time.

Is these any code that will create a label for every item in that named range and rename it's caption?

Thanks in advance
Kev

 

[Damon Ostrander]

Hi jinx_uk_98,

I'm wondering if there is an upper limit to the number of cells that the named range can be sized to include. If not, this presents somewhat of a problem for the design of the form--making it automatically size arbitrarily large.

But if there is some reasonable upper limit, then I would recommend that you design the form with this upper limit of Labels pre-sized and pre-positioned on it--then making the unused labels (that are in excess of the number needed) invisible by setting their Visible properties to False. This is a lot simpler than adding new labels to (or deleting old from) the form at run time.

The best way to loop through all the cells in the range and set the Visible properties and Captions of the labels depends upon the characteristics of the named range. For example, if the range has a fixed number of columns but a variable number of rows this might suggest simply using the number of rows in the range to calculate the range of Label numbers that would need to be set.

I hope this helps.

Damon