textbox1.ControlSource = Worksheets(2).Range("B1").Address(External:=True)

--
Regards,
Tom Ogilvy


"Bill" wrote in message
...
Looking for the correct syntax for the ControlSource Property.

Currentl syntax is: textbox1.ControlSource = Worksheets(2).Range("B1")

This however produces the error Run-time Error 380, Could not set
property, invalid property value.

Thanks in advance for your help.