Thread
:
Looking for Help in modifying a code
View Single Post
#
7
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
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
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson