Sorry that should be Userform1.Show

--

HTH

RP

"davo64" wrote in message
...

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

I have a workbook with multiple worksheets. two particular sheets get
data from other sheets. I want a form to open if the value of a cell
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 the
worksheet object or need to create a module or constantly running
macro???

Thanks.
Davo64


--
davo64
------------------------------------------------------------------------
davo64's Profile:
http://www.excelforum.com/member.php...o&userid=15504
View this thread: http://www.excelforum.com/showthread...hreadid=270778