ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBmodeless (https://www.excelbanter.com/excel-programming/302347-vbmodeless.html)

No Name

VBmodeless
 
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 .
THanks in advance for any help you can give.
jeffP
.



All times are GMT +1. The time now is 05:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com