Formula in cell becomes ineffective when other cells updated from userform

[KK1234]

Hi all,
Contents formula =countif(B1:D1,"YES").
This works fine.
Column1 has simple formula to count if text is equal to 'YES'.
But when I double click any cell in column 1 to open userform and update values in column 2,3,4
then the formula in column1 does not work.
I did try to figure out why? but need some help please.
Thanks. sample book attached
Kind regards

[buran]

Hi, when you open the form you take the current result from the formula in the TextBox1. When click update you overwrite the cell with the formula and put in the cell this OLD value from TextBox1.

[KK1234]

Hi buran,
Thanks.
To be honest , can you explain a bit more on this and if possible how would you achieve solution.
Many thanks

[buran]

In your form you have 4 textboxes. TextBox1 is populated with the value from column A when you open the form. The other 3 are populated with values from columns B:D. When you click update buton, you overwrite the formula and place in column A the value from textbox1, which is the count WHEN THE FORM WAS OPENED, not after the update.
The solution:

Please Login or Register  to view this content.

Note that I also changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

. You must change CommandButton2_Click sub the same way. Hide only hides the form, I believe you want to unload it.
Also instead of UserForm_Activate, i think it's better to use UserForm_Initialize.

[KK1234]

OK buran,
I will try and get back to you.

[KK1234]

OK buran,
I will try and get back to you.

[KK1234]

Hi,
Actually I never realised what you have explained.
Now understood it fully.
A great learning for me.
Thanks again
Kind regards