Averaging Text box values excluding blanks in VBA

Hello,

This is my second post on this forum, and I apologize if I do anything incorrectly (I have read the rules and am making every attempt to follow them).

I have created a sample file (TEST1 attached) to illustrate my questions. In the userform, I have textbox5 averaging when data is entered into textboxes 1-4. It seems like an easy fix, but I cannot figure it out today.

1.) How do I change the calculation to average only the cells with values in them?
2.) Does the code have to be input into each textbox_change command in order to work or is there a more efficient way?

That seems like a good place to start. Thank you in advance for your time and assistance.

Nolan

1) see the code below. It checks that a textbox contains a number before it adds it to the runnign sum.
2) there are several ways to do this, but all generate about the same amount of code. VBA will not allow you to share event handlers between controls.

Please Login or Register  to view this content.

Try this...

Please Login or Register  to view this content.