Any recommendations on how to shorten my code, OR AT LEAST How to write it on mutiple lines so that I can see it all without having to scroll on screen?
Can I somehow use the "_" (underscore) that I have seen been used before?
varNewDateAnswer = Msgbox("Your current Contract dates are:" & vbLf & vbLf & "DESIGN:" & Chr(9) & Chr(9) & Chr(32) & DesignDate & Chr(9) & "for " & oldDesign_rowsCount & " month(s)" & vbLf & "CONSTRUCTION:" & Chr(9) & Chr(32) & ConstDate & Chr(9) & "for " & oldConst_rowsCount & " month(s)" & vbLf & "POST-OCCUPANCY:" & Chr(9) & Chr(32) & PostDate & Chr(9) & "for " & oldPost_rowsCount & " month(s)" & vbLf & vbLf & "Do you need to change them?!", vbYesNoCancel + vbQuestion)
Bookmarks