Quick way to add the value in many textboxes in a userform

[birdieman]

I have a userform in which I need to add the values in about 25 textboxes (there are formatted numbers in the boxes, like $5,000). Is there a quick and easy way to do it without adding one by one (TextBox50 + TextBox52, etc.)? If it helps, the names/labels are all TextBoxXX (XX is a number) and all TextBox numbers are EVEN numbers between 50 and 100. Thanks

 

[Norie]

Do you want to add all of the textboxes or is it pairs of textboxes?

Where should the result(s) go?

 

[birdieman]

I want to add the values in all EVEN textboxes from say Textbox150 to TextBox198 (Textbox 150+ textbox 152 + textbox 154....+TextBox198) and put result in Textbox200

 

[Norie]

Are they all formatted the same?

 

[Norie]

Note I'm asking about formatting because we need to convert the text in the textboxes to numeric to add the values, looping through the textboxes is the easy part.

For example to loop through every even textbox from 150 to 198 we can use this.

For I = 150 To 198 Step 2
    MsgBox Me.Controls("Textbox" & I).Value
Next I

 

[birdieman]

yes, all are formatted "$##,##0". Some may not be that long but all are $#.