Guest User

Untitled

a guest
May 22nd, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. Private Sub CommandButton6_Click()
  2.  
  3. sMo = lastMonth
  4. vDte = sMo & "1, " & cboYr
  5. vMo = Month(vDte)
  6.  
  7. 'set fiscal month ACTUAL year
  8. If vMo > 4 Then vDte = DateAdd("yyyy", -1, vDte)
  9.  
  10. TextBox2 = TextBox1.Value & Format(vDte, "mmyy")
  11. TextBox3 = "Sales Rebate Due - " & UCase(Format(vDte, "mmm yyyy"))
  12.  
  13. End Sub
Add Comment
Please, Sign In to add comment