View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jnf40 jnf40 is offline
external usenet poster
 
Posts: 103
Default Click an Optionbutton

I have a workbook, wb1, that when a different date is entered in a cell then
a new workbook, wb2, is opened with everything the same as the previous
workbook. There are 7 optionbuttons, group 1 contains optionbuttons 1 and 2,
group 2 contains optionbuttons 3 and 4 and group 3 contains optionbuttons 5,
6, and 7. When wb2 opens I want the values of the optiobuttons in wb1 to be
transfered to the optionbuttons in wb2. The optionbuttons are linked to cells
by code.