Results 1 to 40 of 65

Thread: Looping to put numbers in a 9x9 grid of Text Boxes

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2005
    Location
    UK
    Posts
    15

    Looping to put numbers in a 9x9 grid of Text Boxes

    I'm trying to make a sub that can cycle through all of the text boxes and input a number into each one (a square grid 9x9). I thought of possibly using two loops (one vertical, one horizontal) to go through and make a string by making it equal to e.g. "Row" & v & "Col" & h (where v & h are variable integers). What I'm not sure on here is how to get the code to look up that object as I would normally do something like "Text.value = String" but how could I get the code to replace "Text" in this phrase? Or would there be a better way of doing it? In case something similar like this has been said before, I just want to say that I wasn't exactly sure what to search on for this. Thanks in advance.
    Last edited by AdmiralJonB; May 30th, 2005 at 03:28 PM. Reason: New Title

Posting Permissions

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



Click Here to Expand Forum to Full Width