suspending-interacting-resuming
 

Hi,

I've written a routine that checks a few numbers on a worksheet.

When a number doesn't match a criterium, I .activate the offending cell,
and pop a msgbox stating the problem. Now excel waits until I push the OK
button, but I would like to enter another value in my cell, and THEN click
the OK button.

How can this be done ?


thx

Ward

suspending-interacting-resuming
 

Instead of a MsgBox (which is always modal, in other words
it always keeps focus until you close it) you will need to
create a UserForm and set its ShowModal property to False -
this will allow the user to interact with Excel while the
form is still showing.

-----Original Message-----
Hi,

I've written a routine that checks a few numbers on a
worksheet.

When a number doesn't match a criterium, I .activate the
offending cell,
and pop a msgbox stating the problem. Now excel waits
until I push the OK
button, but I would like to enter another value in my
cell, and THEN click
the OK button.

How can this be done ?


thx

Ward
.