SUM textbox Values within frame

[mhe5026]

I set up a grid of 12 x 12 textboxes within a frame, so (144 individual boxes) that allow a user to input a number. I was unsure if there was another way of summing the values together in that frame without doing, Val(textbox1) + Val(textbox2) + Val(textbox3)... Also, this is all within a user form, not in excel, the input data will be implemented into excel later. I am making a calculator of sort.

 

[Domenic]

Try something like this...

<font face=Calibri><SPAN style="color:#00007F">Dim</SPAN> Ctrl <SPAN style="color:#00007F">As</SPAN> Control<br><SPAN style="color:#00007F">Dim</SPAN> MySum <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Double</SPAN><br><br>MySum = 0<br><SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> Ctrl <SPAN style="color:#00007F">In</SPAN> Me.Frame1.Controls<br>    <SPAN style="color:#00007F">If</SPAN> TypeName(Ctrl) = "TextBox" <SPAN style="color:#00007F">Then</SPAN><br>        MySum = MySum + Val(Ctrl.Value)<br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br><SPAN style="color:#00007F">Next</SPAN> Ctrl<br><br>MsgBox MySum<br>    </FONT>

Hope this helps!

 

[mhe5026]

yes it worked great! only thing is what if i want the summed value to go into a textbox on the userform somewhere else, not in that frame instead of the message box.

 

[mhe5026]

Figured it out lol, thanks for the first part!!

 

[Domenic]

Try...

Me.TextBox145.Value = MySum

Change the name of the textbox, accordingly.

Hope this helps!

 

[Domenic]

That's great, I'm glad you've figured it out.

Cheers!