If it's really called "Sheet1", what you are doing should work.

To validate, activate the sheet and in the immediate window type

?range("B1").Address(External:=True)

You should see something like

[Book2]Sheet1!$B$1

Validate everything after the Book2 part is the ControlSource

--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility



"Jeff Ciaccio" wrote in message
...
When I try to set this directly in the controlSource property of the
textBox (in the properties window), I get an error
"Could not set the control source property. Invalid property value"


"Rick Rothstein (MVP - VB)" wrote in
message ...
1) How do you specify a certain worksheet in the properties? I tried
sheet1!B1, worksheet(1).range("b1"), and a few others, but none of these
seemed to work.

Sheet2!B1 works for me. Why do you think it isn't working?

Rick