Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Whole number
If the number is the same as it's integer and greater than zero, isn't it a whole number ? if MYNUMBER >= 0 and int(MYNUMBER) = MYNUMBER then msgbox "I AM WHOLE"- BUDBDL
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Placing a formula in VBA
Sorry, I goofed the 1st comment line ... ' Make sure you're in the correct workbook Dim obj As Object Set obj = Activeworkbook ' Make sure you're on the correct sheet Worksheets("Sheet1").Select ' Add sample Values for this example ActiveSheet.Range("B2").Value = 2...- BUDBDL
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Placing a formula in VBA
' Make sure you're in the correct Dim obj As Object Set obj = Activeworkbook workbook ' Make sure you're on the correct sheet Worksheets("Sheet1").Select ' Add sample Values for this example ActiveSheet.Range("B2").Value = 2 ActiveSheet.Range("C2").Value = 3 ' Insert a formula...- BUDBDL
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
