Hi guys,

I've read a lot of posts and they don't agree on how to reference cells in
the Control Source and the Row Source Proprieties of a ListBox or ComboBox.
I've tried the short form ("Sheet1!A1") and the long form
(Workbooks("Book1").Worksheets("Sheet1").Range("A1 ") or even the longer one,
with .Address at the end. NONE OF THESE ARE STABLE. They sometimes work and
sometimes, I get the "Could not set Property Value....."

Isn't there ONE RIGHT way to tell a control where to get its data? If not,
then what are the rules for using one instead of the other?

Thanks for lighting my path,
Marc