syntax for Control Source

what is the correct syntax to type into the properties box for a control source?

I have tried =Sheets("A").Range("joe") where joe=defined name

Uggg, this sb 101

You are talking about what to enter directly into the properties box, not using VBA, correct? If so, try

joe

-or-

A!joe

HTH

Jason

Yes, that is/was it.

Thanks Jason!

No problem. Glad I could help.