Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Listbox rowsource on Userform
Hi
I'm trying to set the rowsource of a listbox, I keep getting subscript out of range error. Thanks Wendy Private Sub UserForm_Initialize() Dim LastRowNo As Long Dim LastRow as String Set ws = Workbooks("post.xls").Worksheets("data") 'find first empty row in sheet LastRowNo = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row LastRow = "A2:C" & LastRowNo Me.ListBox1.RowSource = LastRow End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listbox in UserForm | Excel Discussion (Misc queries) | |||
How to load a listbox in a userform? | Excel Discussion (Misc queries) | |||
???Help??? Userform.Listbox.rowsource = ??? | Excel Discussion (Misc queries) | |||
UserForm Listbox issue | Excel Discussion (Misc queries) | |||
UserForm Listbox in VBC | Excel Discussion (Misc queries) |