Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RowSource in ListBox
Is it possible to have the rowsource in a listbox set to the following range
("rng") that I have defined in a vb module? I keep getting the following message: "Could not set the RowSource property. Invalid property value." Do I need to insert the code somewhere else? Thank you! ---- Dim rng As Range lastrow = Cells(1, 1).End(xlDown).Row rng = Sheet1.Range(Cells(1, 1), Cells(lastrow, 2)) ---------- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
RowSource in ListBox
Hi Noah:
Try Dim rng As Range lastrow = Cells(1, 1).End(xlDown).Row Set rng = Sheet1.Range(Sheet1.Cells(1, 1), Sheet1.Cells(lastrow, 2)) Me.ListBox1.RowSource = rng.Address -- http://www.vba.com.tw/plog/ "Noah" wrote: Is it possible to have the rowsource in a listbox set to the following range ("rng") that I have defined in a vb module? I keep getting the following message: "Could not set the RowSource property. Invalid property value." Do I need to insert the code somewhere else? Thank you! ---- Dim rng As Range lastrow = Cells(1, 1).End(xlDown).Row rng = Sheet1.Range(Cells(1, 1), Cells(lastrow, 2)) ---------- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
RowSource in ListBox
Thank you for your help, but, unfortunately, I still can't seem to get it to
work. Since several days have elapsed since the original post, I will post the question again. "chijanzen" wrote: Hi Noah: Try Dim rng As Range lastrow = Cells(1, 1).End(xlDown).Row Set rng = Sheet1.Range(Sheet1.Cells(1, 1), Sheet1.Cells(lastrow, 2)) Me.ListBox1.RowSource = rng.Address -- http://www.vba.com.tw/plog/ "Noah" wrote: Is it possible to have the rowsource in a listbox set to the following range ("rng") that I have defined in a vb module? I keep getting the following message: "Could not set the RowSource property. Invalid property value." Do I need to insert the code somewhere else? Thank you! ---- Dim rng As Range lastrow = Cells(1, 1).End(xlDown).Row rng = Sheet1.Range(Cells(1, 1), Cells(lastrow, 2)) ---------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listbox rowsource on Userform | Excel Discussion (Misc queries) | |||
RowSource in ListBox | Excel Programming | |||
ListBox Rowsource Limitation?? | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
listbox rowsource | Excel Programming |