try these -

"'" & sheet-name & "'!" & cell.address

or

mySingleCellRangeObject.address(external:=true)

Regards,
Peter T


"jam9663" wrote in message
...
I am trying to set a TextBox ControlSource from a UserForm to link to a
different worksheet..... I use the syntax
UserForm.TextBoxxxx.ControlSource =
Worksheets(#).Range("Cell#") yet when I go to run it I keep getting an
error
message. What would be the correct syntax for this....or can I even do
this
with VB???