View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LRay67 LRay67 is offline
external usenet poster
 
Posts: 49
Default Textbox from 1st worksheet to textbox to other multiple sheets

I am trying to copy a textbox to another textbox in multiple sheets within
the workbook. Below is what I use to copy to one additional worksheet, but
not multiple worksheets after the 2nd. Can anyone help? Thanks

Worksheets(2).Range("A1") = Worksheets(1).TextBox1.Value

Linda