Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interacting with 2 different excel files | Excel Discussion (Misc queries) | |||
Problem interacting between VB.NET and VBA6 with Excel 2003 | Excel Discussion (Misc queries) | |||
Interacting outside Excel | Excel Programming | |||
Interacting with Explorer | Excel Programming | |||
Resuming code after closing a print preview | Excel Programming |