clng() tries to convert strings to numbers (integers).

See VBA's help for more info.

wrote:

<<snipped

thank you. Sorry about i don't know the function "Clng()".
I would like to test if the cell value number "0" then hide. However,
since it is userform, if user key in any non-integer accidentally, it
will occur error. So to prevent this, i have to test the input value
if not integer it will prompt out a message box.
Thanks for your help.

--

Dave Peterson