Validate result in a calculated cell

**judasdac** · 08-10-2009, 02:08 PM

Hi All,
I've been struggling with this for a little while today and quite can't seem to figure it out. I have a range --- A6:A28 --- where a user will enter a percentage. The total should add up to a 100%, which is in cell A30.

My understanding is that a need a worksheet_calculate function to tell users to revise their entries if the results in a cell A30 are either less than or more than 100%.

This is the simple, non-working procedure I have now:

Please Login or Register  to view this content.

Any ideas? I've attached the worksheet.

Thanks in advance for the help

**DonkeyOte** · 08-10-2009, 03:29 PM

are you sure you mean A30...

**judasdac** · 08-10-2009, 04:08 PM

LOL!!! Well that was pretty silly. Thanks for the heads up :-)

One quick question: Any advice on the best way to call this sub? I'm thinking of creating a "calculate" button for the users, but don't know if that's really the best way.

**DonkeyOte** · 08-10-2009, 04:12 PM

If the file is set to Auto Calculate the code will be invoked automatically whenever the sheet is recalculated... for info. on calculation why / when it occurs see: http://www.decisionmodels.com/calcsecrets.htm