View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Looking for Help in modifying a code

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