Advertisement
Guest User

Untitled

a guest
Jul 18th, 2018
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. Sub Workbook_open()
  2. Call test ' for starting timer again
  3. End Sub
  4.  
  5. Sub test()
  6. Dim r As Long
  7. Dim Msg As String
  8. With Sheets("Foglio1")
  9. For r = 2 To 68
  10. If .Range("H" & r).Value > 0 And .Range("L1").Value >= .Range("H" & r).Value Then
  11. Msg = Msg & vbLf & .Range("H" & r).Value & " (RIGA " & r & ") 1 Settimana Rimanente"
  12. End If
  13. Next r
  14.  
  15. For r = 2 To 68
  16. If .Range("I" & r).Value > 0 And .Range("L1").Value >= .Range("I" & r).Value Then
  17. Msg = Msg & vbLf & .Range("I" & r).Value & " (RIGA " & r & ") 1 Settimana Rimanente"
  18. End If
  19. Next r
  20. End With
  21. MsgBox Msg
  22.  
  23. Application.OnTime Now + TimeValue("00:01:00"), "Foglio1.Workbook_open"
  24. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement