VBA code to determine program logic; if X divided by Y is an integer

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • stephie3883
    New Member
    • Feb 2013
    • 6

    VBA code to determine program logic; if X divided by Y is an integer

    Determine if the result of integer X divided by integer Y is an integer.
    X=55 and Y=11

    Code:
    Sub is_integer()
    Dim X As Integer
    Dim Y As Integer
    
    X=55
    Y=11
    
    End Sub
    I understand VB uses / to represent division, but what command provides the program logic of it?
    Last edited by Rabbit; Feb 28 '13, 04:58 AM. Reason: Please use code tags when posting code.
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Please use code tags when posting code.

    You can use the Mod operator to see if there is a remainder.

    Comment

    Working...