How To Add Multiple Textboxes Together on a Userform (SUM, AVERAGE, etc)

[@wayneedmondson1065]

Awesome example Dan! Interesting and well explained. Thanks for sharing! Thumbs up!!

[@ExcelVbaIsFun]

Thanks Wayne! Always appreciated, bud!

[@querrythis]

Thank you so so much. Perfect example for what I needed.

[@ExcelVbaIsFun]

That's awesome Mr E - thanks for the comment. So glad it helps! :)

[@SnifterRoux]

Instead of Textbox1, TextBox2, ... Mine is more like TextBox, TextBox_2, ... I have tried cVal = cVal + CDbl(Me.Controls("TextBox_" & i) + ("TextBox") I can't get it to include TextBox, it only includes TextBox_2, TextBox_3, ... How would I make this work? There is too much code to edit to change the name of all the 1st textboxes, but also it would be nice how to include textboxes with entirely different names. Thanks

[@carlo9567]

The answer to my question. Thank you so much🙂

[@ExcelVbaIsFun]

Hey Carlo, thanks for a great question - it was a fun one to answer! If you get a second for some feed back, please give it here: www.excelvbaisfun.com/videoask

[@keeskkool]

Hi there, what is the best way to store, catalog, index VBA code/ projets codes...

[@choyaguirre3021]

Hi, done this but prompt an error “Type Mismatch”

[@sasirekha9975]

Hello sir, could you please help me to get a code for the scenario... We have set of checkbox fields available in userform 1 .we have selected only few from the list. On clicking submit button in userform 1. Second userform should display with selected checkbox value from userform 1. Thanks in advance!