Thread: Syntax for TextBox ControlSource Property to another worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jam9663 jam9663 is offline
external usenet poster
  
Posts: 1
Default Syntax for TextBox ControlSource Property to another worksheet
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???
Reply With QuoteReply With Quote