Advertisement
Guest User

Edit table with userform VBA

a guest
Jun 15th, 2015
282
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. Private Sub ComboCompanyname_Change()
  2.  
  3.  
  4. Me.Question1.Value = ws.Cells(iRow, 1).Value
  5. Me.Question2.Value = ws.Cells(iRow, 2).Value
  6. Me.Question3.Value = ws.Cells(iRow, 3).Value
  7. Me.Question4.Value = ws.Cells(iRow, 4).Value
  8. Me.Question5.Value = ws.Cells(iRow, 5).Value
  9. Me.Question6.Value = ws.Cells(iRow, 6).Value
  10. Me.Question7.Value = ws.Cells(iRow, 7).Value
  11.  
  12. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement