VBmodeless

[Guest]

courtesy of Excel Programming by Jinjer Simon, Chapetr 13
page 232. "The default value of vbmodal makes the dialog
box modal, which menas that you must enter close or hide
the dialog box before selecting any other option within
Excel." "A value of vbmodeless means that although the
dialog box remains open until a user closes it, a user can
perform other program options."

-----Original Message-----
CAn someone tell me where to read what this is? VBHelp says nothing.

Second queston I'm returning a value (integer) from a

input box and getting error mismatch types when clicking
Cancel (or escape).

I read here how ot check against the "" that Cancel

returns but I can't because of teh mismatch.

I'd also like to validate the input (no text, two digits,

no decimal point) data but do'nt know how .