range name as rowsource of listbox?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thanks Michael for your response, you put me on the right track.
I found that in
cbxCat1.RowSource = "Category"
Click to expand...
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
 
Back
Top