Re: simple question

From: William (willwest22_at_yahoo.com)
Date: 01/09/05 

Date: Sun, 9 Jan 2005 08:50:05 -0000

Correction to my previous post - place the code in the relevant work***
module and not the ThisWorkbook module - apologies. 

-- 
XL2002
Regards
William
willwest22@yahoo.com
"someguy" <inderjitrai@yahoo.com> wrote in message
news:Xns95D923C55D269inderjitraiyahoocom@216.196.97.142...
| Hi,
|
|     This seems like it should be a fairly simple task but i'm new to vba
| and can't seem to figure it out.  I have 2 cells in excel whose values
have
| to add up to 1.0.  If the user changes the values in any cell and their
| total value is not equal to one, a popup window should notify the user.
| I've written the fuction in VB but how do i call it when the user changes
| the cell values?  Many thanks.
|
| TIA