Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Thanks. If you were wondering, I was trying to use the a and b a index numbers to reference a specific cell. Just because you wer curious, I have 13 pairs of cells and 13 text boxes. Each text bo corresponds with a pair of cells. Each of the pairs of cells will hav three possible configurations. 1: Both are "n/a" 2: The first is number and the second is "n/a", or 3: Both are numbers. Here are three examples of what I want it to do. Cells H3, and I3 contain "n/a", when I click "Calculate" text box t will get "n/a" Cell H4 contains a 15, and Cell I4 contains "n/a", t2 will get "15" Cell H5 contains a 15, and Cell I5 contains a 15, t3 will get "15,15" My problem with it was that I know how to increment the cell inde numbers to reference the next set of cells, but I don't know how t name the text box so that I can increment it corresponding to th incremented cell pair(if any of that makes sense. Thanks for the help Ill try it out and see if I can figure something out -- skrimp ----------------------------------------------------------------------- skrimpy's Profile: http://www.excelforum.com/member.php...fo&userid=1463 View this thread: http://www.excelforum.com/showthread.php?threadid=26346 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
Looping through text boxes | Excel Programming | |||
Looping Text | Excel Programming | |||
looping through text boxes | Excel Programming | |||
Looping through Text boxes | Excel Programming |