automatic macro

Posted by Jan on July 25, 2001 1:01 AM

Hello,

does anybody know how I can automatically start a macro after a value has been typed into a certain cell and the entry has been confirmed by hitting "enter" ?

Thanks for any help

Jan

Posted by Ivan F Moala on July 25, 2001 1:59 AM

Posted by Ivan F Moala on July 25, 2001 2:03 AM

Jan
Have a look @ online help for Application events;
Specifically-
Private Sub Worksheet_Change(ByVal Target As Range)

do a search on "Worksheet Object Events"
Should be examples here......if further help
needed then repost with specifics and Excel Version.

Ivan

Posted by Bob on July 25, 2001 6:29 AM

See Dax's answer to Andrew from 7/20/01

Dax answered this very question from Andrew 5 days ago. I read this myself and have since made considerable use of this feature. (It is neat!)