Ah! Very clever Susan!! This DG never ceases to amaze me. In fact, it is
only a rare occasion that I am amazed less than ten times per day by the
information posted here.
"Susan" wrote:
i'm glad you got it working! i don't think what you proposed can be
done using microsoft messageboxes. however, you could easily do it
using USERFORMS that you have designed (very cleverly) to look exactly
like a microsoft messagebox. the userforms would be called in
sequence and would be numbered or named.
:)
i think i might try that (just as a test).
susan
On Aug 6, 4:54 pm, ryguy7272
wrote:
Thanks for pointing me in that direction Susan. I went with this:
...blah, blah, blah...
Case vbNo '#3
MsgBox "You answered no. Please start again!!"
Exit Sub
Out of curiosity, can the thing I proposed be done? Can a msgbox be named
or somehow identified and then referenced in some sort of loop or sequence?
Cordially,
Ryan---
"Susan" wrote:
imho, i would not use a case select structure here, because you're
only dealing with three (i think) very small commands. i think you'd
do better with a simple if then structure.
if message1 = vb yes then
go ahead & do your stuff
else
msgbox don't do that!
exit sub
end if
:)
susan
<snip