Text Box Data Entry omitting number '9'

[mashiulalam]

Hi,

I am trying to enter data in a text box but with these code it does not allow me to enter number '9'. What am I missing?

Please Login or Register  to view this content.

Please help!

Mashiul

[LJMetzger]

Hi mashiulalam,

a. Try KeyAscii <= vbKey9
b. Please note that vbKey may be incorrect. 'Option Explicit' at the top of each code module should help you if this is a problem.

It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

Lewis

[mashiulalam]

LJMetzer,

KeyAscii <=vbKey9 worked.

Great to know about Option explicit.

Thanks a lot.

Regards,

Mashiul