Glaswegian
10-04-2007, 02:34 AM
Hi folks
I have 2 sets of optionbuttons - each one is being used as a Yes/No answer to a question. Depending on the answer, text is either hidden or revealed. All pretty simple.
However, if I leave the sheet, having chosen an option, when I return, both optionbuttons are blank - the selected values are not being retained. This is repeated over 3 sheets - each sheet has the same buttons and questions. There is no code running to clear the options. Below is the code for one of the buttons, just for info...
Private Sub OptionButton5_Click()
If OptionButton5 Then Range("P15").Font.ColorIndex = 5
End Sub
Why won't they retain their selected value?
I have 2 sets of optionbuttons - each one is being used as a Yes/No answer to a question. Depending on the answer, text is either hidden or revealed. All pretty simple.
However, if I leave the sheet, having chosen an option, when I return, both optionbuttons are blank - the selected values are not being retained. This is repeated over 3 sheets - each sheet has the same buttons and questions. There is no code running to clear the options. Below is the code for one of the buttons, just for info...
Private Sub OptionButton5_Click()
If OptionButton5 Then Range("P15").Font.ColorIndex = 5
End Sub
Why won't they retain their selected value?