VBA CountIf logic checking Text Box Input

Hi Everyone,

Well I didn't think that I would be stopped here, but I'm having issues understanding the logic associated with basic excel functions when their used in VBA code. I'm trying to use the "CountIf" function inside my VBA code to count the total text boxes that have no value entered into them. I need to run this total through a later equation to account for the total number survey questions not answered. The logic should look like this:

• Count if "textbox A" has no value

+

• Count if "textbox B" has no value

+ .....N = 20 text boxes.

At the moment my attempts look like this:

Formula:

Please Login or Register  to view this content.

The full equation would be: (60 - ((Total number empty text boxes) * 3))

I've added my worksheet in question in case I'm not explaining clearly enough. The code is under our calculate button for our "Penn Shoulder" user form.

Thank you Everyone!

Hi Alan,

Thank you for the insight into the underscore and enter key aspect. I had seen and incorporated that before, but I was at a loss as to understanding it. Unfortunately that alone does not seem to be correcting my CountIf function. I'm receiving the following error:

Runtime Error 13.
Type mismash.

I've updated the VBA to reflect a more clearly identifiable codeset in the attachement. I hope this helps which is the same below:

Formula:

Please Login or Register  to view this content.

I think it doesn't work, because the first parameter in CountIf function must be Range

Hi Everyone,

I've gone back and cleaned up my code and tried declaring my "EvalNotScored" variable as a range, but to no avail. If anyone has any further suggestions on how to develop a functioning CountIf statement inside of VBA, I would greatly appreciate it. I've included my updated version of this workbook below. Again, the User form in question is the "Penn Shoulder" and the button that will execute the CountIf statement could the the "PennShoulderCalculateButton" button.

And of course, thank you for the suggestions thus far.