View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default copying many controls

I'm going to have many controls that get their values from sheet1, all on a
multipage. Then I'll have sheet2, & sheet3, and also pages on the multipage
that are identical to the first page, except they get their data from sheet2,
sheet3. Their are 40-50 controls each page, each page identical, just using
a different sheet, which are identical. Can I 'copy' one page to the next,
only changing the sheet that is referenced, rather than having to make the
sheet ref change on 40-50 controls?