Re: Run a macro based on the value of a cell

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 20:51:59 +0100

Hi
then you need an event procedure. see:
http://www.cpearson.com/excel/events.htm 

--
Regards
Frank Kabel
Frankfurt, Germany
"Coyote" <Coyote@discussions.microsoft.com> schrieb im Newsbeitrag
news:F1E0072A-048B-4D52-8D99-B6B6A22DEAF3@microsoft.com...
> Hi Everyone
>
> I have what seems to be a simple task but can't seem to figure it
out.  I
> have a excel file that has the tabs "Current User List" & "Prev User
List"
> On these sheets the first row is called "status"  which is either
"curr" or
> "prev" to indicate employee status.  I copied and modified the macro
posted
> on this site for copying an entire row to another wor*** and it
works fine
> but I'd like to go one step further.  If I change the status of an
employee
> on the "Current User List" to "Prev" I want the macro to run so that
the
> record is copied to the "Prev User List automatically.
>
> Any help would be greatly apprciated.
>