|
-
May 30th, 2005, 02:54 PM
#1
Thread Starter
New Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|