Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range name as rowsource of listbox?
Hi All,
Can I use the name of a named range as rowsource of listbox? If so, how? I use XL2000, and when I tried to enter the name in the rowsource field of Properties window, I got a fatal error, that closed the whole XL application. Thanks, Stefi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
range name as rowsource of listbox?
Yes you can and it is entered without the " marks.
If you want to do it on a form using VBA use the following code in the Form_Initialize code window cbxCat1.RowSource = "Category" Replace cbxCat1 & Category with your form name and named range respectively. Note in this instance the " marks are used. Regards Michael "Stefi" wrote in message ... Hi All, Can I use the name of a named range as rowsource of listbox? If so, how? I use XL2000, and when I tried to enter the name in the rowsource field of Properties window, I got a fatal error, that closed the whole XL application. Thanks, Stefi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
range name as rowsource of listbox?
Thanks Michael for your response, you put me on the right track.
I found that in cbxCat1.RowSource = "Category" cbxCat1 is to be replaced with listbox name rather then form name! I found out that my problem was caused by using a non contiguous range in Rowsource! HELP doesn't mention that this is not allowed!!! Regards, Stefi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RowSource in ListBox | Excel Programming | |||
Listbox Rowsource Headings Multi columns Copy Range If Then Conditional | Excel Programming | |||
RowSource in ListBox | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
listbox rowsource | Excel Programming |