I'm pretty new to Excel VB and brand new to this forum. Hope someon
can help with my scenario.

I have a workbook with multiple worksheets. two particular sheets ge
data from other sheets. I want a form to open if the value of a cel
in that worksheet is not equal to zero. I enter the sheet (named dd
by clicking the tab at the bottom. in my mind i'm thinking:

on enter worksheet dd, if cell J55<0, then load Userform1

Userform1 is one I already created. Would I add the code under th
worksheet object or need to create a module or constantly runnin
macro???

Thanks.
Davo6

--
davo6
-----------------------------------------------------------------------
davo64's Profile: http://www.excelforum.com/member.php...fo&userid=1550
View this thread: http://www.excelforum.com/showthread.php?threadid=27077