Want Average on userform textboxes to ignore blank textboxes

I am trying to calculate averages within my userform. Each item is taking two values and needs to average them into a new textbox. There are 28 averages that need to be performed when I click my "average Button"

Please Login or Register  to view this content.

This code works just fine when both textbox2 and 3 have data in them but there is the possibility that one of them will be blank. What do i have to add to this code to make it ignore blank values like the function does in a normal spread sheet? Or is there a different code that will provide these results?

I would recommend that you write your own function.

Please Login or Register  to view this content.

Then

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member.

I also tweaked your title to more accurately reflect your question.

--6StringJazzer