OptionButton value to change from True/False to Yes/No

[danbates]

Hi,

Please can someone help me?

I would like to change the optionbutton value from true to Yes and False to No. Is this possible?

This is the code I have at the moment:

Sheets("Data").Cells(lrcd + 1, "D").Value = OptionButton1.Value

Sheets("Data").Cells(lrcd + 1, "D").Value = OptionButton2.Value

OptionButton1 is labelled as Yes and OptionButton2 as No.

Regards

Dan

 

[JLGWhiz]

An option button has two Boolean values of either True or False. So if you write the code to use the OptionButton.Value you will get the Value based on current status of the button. Selected = True, unselected = False. To get a value of "Yes" or "No" to display in a cell, you would need to write the code something like this.

If OptionButton1.Value = True Then
 Sheets("Data").Cells(lred + 1, "D") = "Yes"
ElseIf OptionButton2.Value = False Then
 Sheets("Data").Cells(lred + 1, "D") = "No"
End If

 

[danbates]

Hi JLGWhiz,

You code has worked just as I wanted, Thank you.

Kind Regards

Dan

 

[JLGWhiz]

Hi JLGWhiz,

You code has worked just as I wanted, Thank you.

Kind Regards

Dan

Glad you could use it,
Regards, JLG