Message Box based on cell value containing formula

[Rahul15292000]

Hi Friends,

I have a formula in cell B65 (=COUNTIF(B45:B64,TRUE)). If the total sum in cell B65 is more then 2, then a message box has to appear. Given below is my code and it does not work in cell B65 as it contain formula. But when I remove formula and manually type(in cell B65) 2,3,4 .... the message box appear. Let me know if I am doing something wrong.

Please Login or Register  to view this content.

Thanks,
Rahul

[Keebellah]

Hi, the problem is that you are testing a fromula, so that means that you don't want people to enter something there.
You not mention what the formula is and what is being added and which range the user fills data that is added up here.
I have attached you macro modified to check any entry in column B above B65 and assuming that B65 is the sum of values in column B

So if the sum exceeds 2 the message box appears

Please Login or Register  to view this content.

Good luck Rahul

[Rahul15292000]

Hi Keebellah,
Thanks for your quick reply. The code you suggested is not working.

The formula I have in Cell B65 is (=COUNTIF(B45:B64,TRUE)). It count the number of 'TRUE' from range B45:B64 and if the total count of 'TRUE' is more then 2 (in cell B65) then the message box need to display message "You exceeded 2".

Hope I am clear now.

[Keebellah]

If you read the code you can change it yourself!!!

Please Login or Register  to view this content.

I just gave you some code YOU did NOT tell me what range, but I expected you would discover that. the red text is the area you mention

This is only triggered if the user enters TRUE or FALSE in that range, if that is a formula too, then you will have to give more information or even a sample file, guessing and assuming is not the best option to help you

[Rahul15292000]

Hi Keeballah, I did change the range in you previous reply and tested it . But even after changing the range, the code is not showing the message box:

[Keebellah]

That means that nothing changes in the range("B45:B64")
If these are formula's too, then it won't work you will just have to do it with a change for the entire sheet and test in the value in B65 >2 that's all

Please Login or Register  to view this content.