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.

Bird	1
Dog	0
Cat	1

<tbody> </tbody>

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

Bird	Dog	Cat
100%	0%	100%
1	0	1

<tbody> </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.