01-28-2006, 11:33 AM
I have the vars(they are integers) d1 to d51(each 1 is set as a textbox value) and I want them to be mutiplied by z all at once. I was wondering how I would loop through those to get em all to multiply by z in a few lines instead of my big long idea.

01-28-2006, 12:15 PM
The best approach would to use a control array of textbox's then you can simply loop through them

Dim i As Integer

For i = Text1.LBound To Text1.UBound

'code to multiply the value
'get the value using Val(Text1(i).Text)

Next i

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum