Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RowSource in ListBox
Hi: Can someone please tell me how to do the following?: I need to specify a multicolumn range in a listBox (RowSource). I wan to specify B6:G?. The first cell of the range is B6. The last cell o the range will be an unkown row in column G. The number of rows wil continue to grow with time. How do I specify B6:G? whereas the represents an infinate row #? Thank you in advance for your help ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
RowSource in ListBox
aet-inc wrote
Hi: Can someone please tell me how to do the following?: I need to specify a multicolumn range in a listBox (RowSource). I want to specify B6:G?. The first cell of the range is B6. The last cell of the range will be an unkown row in column G. The number of rows will continue to grow with time. How do I specify B6:G? whereas the ? represents an infinate row #? Thank you in advance for your help! Any time the ? changes you need to set the RowSource property. Steve. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listbox rowsource on Userform | Excel Discussion (Misc queries) | |||
???Help??? Userform.Listbox.rowsource = ??? | Excel Discussion (Misc queries) | |||
ListBox Rowsource Limitation?? | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
listbox rowsource | Excel Programming |