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

I should have mentioned that I am using XL2003... I see you are using
XL2000... I don't have XL2000 so perhaps the ability to do this did not
exist on your version (and earlier) of Excel. Hopefully, someone with XL2000
will come along and confirm this one way or the other.

Rick


"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

It works for me in XL2000.


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


"Rick Rothstein (MVP - VB)" wrote in
message ...
I should have mentioned that I am using XL2003... I see you are using
XL2000... I don't have XL2000 so perhaps the ability to do this did not
exist on your version (and earlier) of Excel. Hopefully, someone with
XL2000 will come along and confirm this one way or the other.

Rick


"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

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