Guest User

Untitled

a guest
Aug 18th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. Populating a list box with data from worksheet
  2. Type Mismatch
  3.  
  4. With Worksheets(CourseSelection).Range("A3")
  5. Set TaskList = Range(.Offset(0, 1), .End(xlToRight))
  6. End With
  7.  
  8. frmTaskSelection.lbTasks.RowSource = TaskList
  9.  
  10. Sub test()
  11. Dim ws As Worksheet
  12. Dim rng1 As Range
  13. Set ws = Worksheets("CourseSelection")
  14. Set rng1 = ws.Range(ws.[a3], ws.Cells(Rows.Count, "A").End(xlUp))
  15. frmTaskSelection.lbTasks.RowSource = "'" & ws.Name & "'!" & rng1.Address
  16. frmTaskSelection.Show
  17. End Sub
Add Comment
Please, Sign In to add comment