Textbox Empty to Return 0 as value to the cell

[lazyserv]

Greetings to all excel gurus,

May I know what is the possible way to achieve for what I want the UserForm to be?

I have 26 text box to be fill and all these text box can leave for empty if there is no sales to enter.

However I notice is empty text box it would cause my autosum not working correct therefore is it anyway I can replace the empty textbox value to 0 by default?

Here is my VBA code:

Please Login or Register  to view this content.

Thank you.

[humdingaling]

you could just set up the default value to be 0

or you could put "0" + infront

Please Login or Register  to view this content.

ps you should probably write a loop for your code...instead of having to write up the thing 20 odd times

[lazyserv]

you could just set up the default value to be 0

or you could put "0" + infront

Please Login or Register  to view this content.

ps you should probably write a loop for your code...instead of having to write up the thing 20 odd times

Problem solved! thanks mate!! +rep for your help