Guest User

Untitled

a guest
Jan 18th, 2019
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. If (Me.cboCo.Value) = ws.Cells(iRow, 1) Then
  2. Me.cboCat = ws.Cells(iRow, 19).Value
  3. Me.cboCat = ws.Cells(iRow, 19).Value
  4. Me.cboYrApprv = ws.Cells(iRow, 14).Value
  5. Me.txtContact = ws.Cells(iRow, 2).Value
  6. Me.txtPhone = ws.Cells(iRow, 3).Value
  7. Me.txtEmail = ws.Cells(iRow, 4).Value
  8. Me.txtCoAdd = ws.Cells(iRow, 5).Value
  9. Me.txtWebSite = ws.Cells(iRow, 6).Value
  10. Me.txtAccred = ws.Cells(iRow, 8).Value
  11. Me.txtStanding = ws.Cells(iRow, 9).Value
  12. Me.txtSince = ws.Cells(iRow, 10).Value
  13. Me.txtNotes = ws.Cells(iRow, 11).Value
  14. Me.txtVerified = ws.Cells(iRow, 12).Value
  15. Me.txtToday = ws.Cells(iRow, 13).Value
  16. Me.txtServProd = ws.Cells(iRow, 7).Value
  17. Me.txtApprvBy = ws.Cells(iRow, 15).Value
  18. Me.txtAprvReas = ws.Cells(iRow, 16).Value
  19. Me.txtOrder = ws.Cells(iRow, 17).Value
  20. Me.txtPurchs = ws.Cells(iRow, 18).Value
  21. End If
Add Comment
Please, Sign In to add comment