simple question

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: someguy (inderjitrai_at_yahoo.com)
Date: 01/09/05 

Date: Sun, 09 Jan 2005 02:30:42 -0600

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

Relevant Pages

  • Re: change cell colour when cell data changes
    ... what should happen if user changes the ... Should color be yellow in order to satisfy the 1st condition ("anything from ... blank or zero to 1.0 cell colour is yellow") ... work out how to do is to change the cell from the original colour to a new ...
    (microsoft.public.excel.misc)
  • Re: Trapping Datagrid Error Message
    ... Paul J. Lay ... so we should do validation at the UI level. ... the above cell by cell validation also has problem when we did not ... If the user changes the current row, ...
    (microsoft.public.dotnet.framework.windowsforms.databinding)
  • Re: Specific cell
    ... Private Sub Worksheet_Change ... To do this, right-click on the sheet tab, select ... > changes the value of a specific cell. ... but I only want to show the message when the user changes the value. ...
    (microsoft.public.excel.programming)
  • specific cell
    ... I am currently building an Excel sheet by using VBA. ... appear when a user changes a value of a specific cell. ...
    (microsoft.public.excel.programming)
  • Re: simple question
    ... module and not the ThisWorkbook module - apologies. ... If the user changes the values in any cell and their ...
    (microsoft.public.excel.programming)