[asbo]

Ok, I have 90-some textboxes and I have to add all the .Text values, which will be integers, together into an interger variable for later usage.

In another instance, I have a button to reset all of the values to "0", but do i have have to do this individually, or could I use another command.

In both situations, I believe I could use a loop, but I have no idea how to use them, much less do this...

Can anyone help?

::Leader of dumb question on the Dev board ::

[TimCottee]

I assume we are talking VB here?

Private Sub cmdAddEmUp_Click()
  MsgBox AddUp()
End Sub

Private Sub cmdReset_Click()
  Dim ctrlReset As Control
  For Each ctrlReset In Controls
    If TypeOf ctrlReset Is TextBox Then
      ctrlReset.Text = ""
    End If
  Next
End Sub

Private Function AddUp() As Integer
  Dim ctrlAdd As Control
  For Each ctrlAdd In Controls
    If TypeOf ctrlAdd Is TextBox Then
      AddUp = AddUp + CInt(ctrlAdd.text)
    End If
  Next
End Function

[asbo]

I don't quite understand the syntax (that could take a couple weeks ), but thanks nonetheless.

[TimCottee]

To explain what is going on, every form has a collection which is the .Controls collection, every control that is on the form whether added at design time or dynamically at runtime is a member of this collection. Therefore we can use iterative methods (For Each .. Of ..) to traverse this collection. Because there is a default object type "Control" which can be used to reference a control of any type we use that as the iterator, we then test that the control is actualy of type "TextBox" and if it is then we can refer to the object we are iterating with as if it were the real textbox on the form.

That may or may not help explain things a little as it sounds much more complicated than it really is.

[Snake~eyes]

Tim, how do you know so much about VB? Are you self taught?

-Snake

[TimCottee]

I am indeed 100% self-taught, though I have learnt as much from participating in sites such as this over the years as I have from experimenting myself.

I am a devout non-reader of manuals so much prefer to figure things out myself and ask for help only when that fails (which it doesn't that often these days).

I pretty much don't do anything other than VB though I do dabble a bit in HTML and a few other languages and have taken on quite a wide variety of projects both within my company and outside so have had a whole range of issues to resolve.

[Snake~eyes]

Originally posted by TimCottee:
I am a devout non-reader of manuals

Yah, I hate reading manuals and stuff.

Im self taught myself on PHP and HTML but C++ and Visual Basic I have were taught to me.

Since I know those I can usually read what a javascript or a asp page does, just from knowning C++ and PHP.

If I learned the syntax of those then I could write them easily too.

Ive just never had any reason to learn asp or javascvript so I don't bother.

Usually the only code I write is web based stuff, I haven't written a non web proggy in quite a while. I never really had the reason too.