Remalay
12-03-2008, 04:20 AM
Guys,
I am sure there must be a relatively simple anwer to this, but I am stumped at locating the resolution... please HELP! :help
I just want to use an incrementing variable to address a series of properties on a userform. E.g. a series of labels numbered from 'Tag1' to 'Tag12'
for x = 1 to 12
LabelName = "Tag" & x
strBoxNm = "Box" & x
LabelName.value = strBoxNm
next x
Hopefully this is a relatively straightforward query.
thanks in advance.
I am sure there must be a relatively simple anwer to this, but I am stumped at locating the resolution... please HELP! :help
I just want to use an incrementing variable to address a series of properties on a userform. E.g. a series of labels numbered from 'Tag1' to 'Tag12'
for x = 1 to 12
LabelName = "Tag" & x
strBoxNm = "Box" & x
LabelName.value = strBoxNm
next x
Hopefully this is a relatively straightforward query.
thanks in advance.