Advertisement
Guest User

Untitled

a guest
Mar 30th, 2017
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. If Trim(TB_staus.Text) = "????" Then
  2. Worksheets("lists").Select
  3. Worksheets("lists").Range("A5").Select
  4. If Worksheets("lists").Range("a5").Offset(1, 0) = CMB_Cavityenter.Value Then
  5. Worksheets("lists").Range("a5").End(xlDown).Select
  6. End If
  7. ActiveCell.Offset(0, 9).Select
  8. acitvecell.Value = Date
  9. Else 'do nothing
  10. End If
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement