In my excel form I have a few options with (Yes, No) as answers. For
which i have used Option button. On completing this form I have a
command button, on clicking the command button the form is attached to
a mail with to address as our depts mail id. How ever the glitch is
when we recieve the form and open it the dots in the option buttion
vanish. What can i do to fix this.

Thanks for your help.

hi,
in your form's initialization sub, add code to set each option button to
true or false;
example:
me.optionbutton1 = true
me.optionbutton2 = false
and so on.....

Regards
FSt1

"Ram" wrote:

In my excel form I have a few options with (Yes, No) as answers. For
which i have used Option button. On completing this form I have a
command button, on clicking the command button the form is attached to
a mail with to address as our depts mail id. How ever the glitch is
when we recieve the form and open it the dots in the option buttion
vanish. What can i do to fix this.

Thanks for your help.

On Jun 10, 3:30 pm, FSt1 wrote:
hi,
in your form's initialization sub, add code to set each option button to
true or false;
example:
me.optionbutton1 = true
me.optionbutton2 = false
and so on.....

Regards
FSt1



"Ram" wrote:
In my excel form I have a few options with (Yes, No) as answers. For
which i have used Option button. On completing this form I have a
command button, on clicking the command button the form is attached to
a mail with to address as our depts mail id. How ever the glitch is
when we recieve the form and open it the dots in the option buttion
vanish. What can i do to fix this.

Thanks for your help.- Hide quoted text -

- Show quoted text -

This what i have in option button intialization

Private Sub Worksheet_Activate()
OptionButton1.Value = False
OptionButton2.Value = False
OptionButton3.Value = False
OptionButton4.Value = False
OptionButton5.Value = False
OptionButton6.Value = False
OptionButton7.Value = False
OptionButton8.Value = False
OptionButton9.Value = False
OptionButton10.Value = False
End Sub

how else do you want me to modify it??

On Jun 11, 10:48 am, Ram wrote:
On Jun 10, 3:30 pm, FSt1 wrote:





hi,
in your form's initialization sub, add code to set each option button to
true or false;
example:
me.optionbutton1 = true
me.optionbutton2 = false
and so on.....

Regards
FSt1

"Ram" wrote:
In my excel form I have a few options with (Yes, No) as answers. For
which i have used Option button. On completing this form I have a
command button, on clicking the command button the form is attached to
a mail with to address as our depts mail id. How ever the glitch is
when we recieve the form and open it the dots in the option buttion
vanish. What can i do to fix this.

Thanks for your help.- Hide quoted text -

- Show quoted text -

This what i have in option button intialization

Private Sub Worksheet_Activate()
OptionButton1.Value = False
OptionButton2.Value = False
OptionButton3.Value = False
OptionButton4.Value = False
OptionButton5.Value = False
OptionButton6.Value = False
OptionButton7.Value = False
OptionButton8.Value = False
OptionButton9.Value = False
OptionButton10.Value = False
End Sub

how else do you want me to modify it??- Hide quoted text -

- Show quoted text -

Will it work if I change all option button values to True??