Consulting

Results 1 to 4 of 4

Thread: Using variable in property names

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Thumbs up SOLVED - Using variable in property names

    Guys,
    I am sure there must be a relatively simple anwer to this, but I am stumped at locating the resolution... please 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'


    [vba]
    for x = 1 to 12
    LabelName = "Tag" & x
    strBoxNm = "Box" & x
    LabelName.value = strBoxNm
    next x
    [/vba]

    Hopefully this is a relatively straightforward query.

    thanks in advance.
    Last edited by Remalay; 12-03-2008 at 05:56 AM. Reason: SOLVED

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •