MsgBox when a certain percentage is reached

[JennV]

Hello there,
SheetA is where a user can input a type of animal and labelit 1 or 0. The sheet is interactive and is in a list form where the user can continuouslyadd animals and labels.

<tbody> [TD="width: 312, bgcolor: transparent"] Bird [/TD]
[TD="width: 312, bgcolor: transparent"] 1 [/TD]
[TD="width: 312, bgcolor: transparent"] Dog [/TD]
[TD="width: 312, bgcolor: transparent"] 0 [/TD]
[TD="width: 312, bgcolor: transparent"] Cat [/TD]
[TD="width: 312, bgcolor: transparent"] 1 [/TD]
[TD="width: 312, bgcolor: transparent"] [/TD]
[TD="width: 312, bgcolor: transparent"] [/TD]
</tbody>

In SheetB, I have a tally of the animals which produces apercentage.

<tbody> [TD="width: 208, bgcolor: transparent"] Bird [/TD]
[TD="width: 208, bgcolor: transparent"] Dog [/TD]
[TD="width: 208, bgcolor: transparent"] Cat [/TD]
[TD="width: 208, bgcolor: transparent"] 100% [/TD]
[TD="width: 208, bgcolor: transparent"] 0% [/TD]
[TD="width: 208, bgcolor: transparent"] 100% [/TD]
[TD="width: 208, bgcolor: transparent"] 1 [/TD]
[TD="width: 208, bgcolor: transparent"] 0 [/TD]
[TD="width: 208, bgcolor: transparent"] 1 [/TD]
[TD="width: 208, bgcolor: transparent"] [/TD]
[TD="width: 208, bgcolor: transparent"] [/TD]
[TD="width: 208, bgcolor: transparent"] [/TD]
</tbody>

I’m wondering if there’s any way I can have a message boxpop-up while the user enters the data on SheetA when it reaches a certainpercentage in SheetB. The trick is, the data entered on SheetA doesn’t gettransferred to SheetB until the user clicks on a ‘Transfer’ button on SheetA.

 

[KOKOSEK]

Instead of trick with button transfer use COUNT formula on SheetB, then into code of SheetB use event Worksheet_Calculate() where you can check values and if >100% gives you msgbox.
Or if you don't want to remove trick with transfer button and then end of 'transfer' macro add checking of these values.