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