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