Userform Yes - No Default

[Moe]

I have a userform that has a simple Yes or No selection, I didn't want to use a message box for certain reasons, I needed a userform. Anyhow, my issue is that the question it is asking the user is very important, and I don't want it to default to YES! I don't want it to default to NO either. Is there a way to not default to anything, but rather force them to click on an option themselves?

Thank you,

Moe

[mangesh_yadav]

You could have the following initialise code for your userform which forces the values for both the optionbuttons to false before opening:

Private Sub UserForm_Initialize()

OptionButton1.Value = False
OptionButton2.Value = False

End Sub

Or simply, in the design stage/mode, set the Value property to false for both the option buttons. The properties view can be obtained from View > Properties mode in the VB editor.

Mangesh

[Moe]

But I'm using commandbuttons, does that make a difference? I don't think I can set the "value" of a command button can I?