View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Click an Optionbutton

What part are you having a problem with?

tim

"jnf40" wrote in message
...
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.