You can not have multiple subs with the same name in the same scope...
so you can have only one Worksheet_Change sub for a give worksheet. You can
however call different subs (defined in standard modules, which do different
things) from the Worksheet_Change sub.


"Trixie" wrote:


Hi,

I've been watching and learning and utilizing some of the simpler VBA
code I've seen (you guys ROCK!), and was wondering how to incorporate
multiple Worksheet_Change subs in one sheet or if it's even possible?

For example I may have a sub that looks at a value and pops me a
msgbox, but also want to use a sub in the same worksheet that hides
rows..

I hope the question makes sense; I am a pretty green on VBA.

Thanks~


--
Trixie

~TRIXIE
------------------------------------------------------------------------
Trixie's Profile: http://www.thecodecage.com/forumz/member.php?userid=438
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109133