I have a series of option buttons on a worksheet. I would like to run them through a routine when a value is changed...but it is not working....help?
VB Code:
  1. Sub ColorMe (opt as OptionButton)
  2. If opt.value = True then
  3. opt.caption= "chosen"
  4. Else
  5. opt.caption = "not"
  6. End if
  7.  
  8.  
  9. Private Sub optNumber1_Change()
  10. ColorMe optNumber1
  11. End Sub