list boxes
Hi Lion,
Note that we can't refference Rowsource of a listbox by sheets name
refference, it should be "A1:A13" format or something ... not
Sheets("name").Range(Blablabla), it will be Error ... unless you
include
on error resume next , the error will be ignored.
Regards,
halim
lionel menuliskan:
i have list box in a form that needs to read a list from a range in a sheet
named "Step"
I have entered in the Row Source block "step!B57:B63"
When I run the procedure, the listbox comes up empty.
I have done this many times before without trouble.
Can you advise??
--
Lionel
|