This if ... then statment will verify if a string inputed from a custom function is an integer
If Val(noOfTransactions) <> Int(Val(noOfTransactions)) Then MsgBox "Please enter an integer", MB_ICONEXCLAMATION, "Error" GoTo menu_dialog: End If
Import
Explore
Relate
Extract
IDEAScripting
Custom Functions
Continous Monitoring
Effective Analytics
Benford's Analysis
Smart Analyzer
IDEA Help Videos
IDEA Related Videos
IDEA Success Stories
Forum List