Goto Command in Code
put code behind form2 to open form1 and close form2
-----Original Message-----
Excel 2k
I have two forms (Form1 & form2). Form 1 has code within
it that checks various cells in a worksheet. I have some
validation within where if the cell value < "" then
Form2
pops up and asks whether the user is sure that they want
to continue and update the worksheet. If they click on
yes, the worksheet appears. If they choose "No", I want
the code to resume in Form1. Although I knows it not good
practice to use the Goto command, its the only solution I
could think off but I can't get it to work. Any help
avaliable??
.
|