Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the following code:
Public Sub SheetCalculate() ' Constants and Variables: Dim iCalc_Work As Integer 'Code: ' Total 4 SVS months cells and put out a message if 12 iCalc_Work = Range("E20") + Range("E21") + Range ("E22") + Range("E23") If iCalc_Work 12 Then MsgBox "Total of SVS phase months must be between 1 and 12" End Sub The same MsgBox displays a total of 5 times. What is triggering the repeated ctin and how do I set it to 1 occurrence? Thansks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Repeating Rows | Excel Discussion (Misc queries) | |||
Repeating Number | Excel Worksheet Functions | |||
Repeating a column | Excel Discussion (Misc queries) | |||
Repeating Above Value | Excel Worksheet Functions | |||
Repeating | Excel Worksheet Functions |