I have a check box that's part of a form and have the information copy to a
data base:

ws.Cells(iRow, 2).Value = Me.txtMemberName.Value
ws.Cells(iRow, 5).Value = Me.TxtDeposits.Value
ws.Cells(iRow, 6).Value = Me.TxtLending.Value
ws.Cells(iRow, 7).Value = Me.CBBroker.Value <---this line
ws.Cells(iRow, 8).Value = Me.Txtmutualfunds.Value
ws.Cells(iRow, 10).Value = Me.txtComments.Value

The value that appears in the data base is "true" How do I simply change
this to say "Yes"

Thanks for your help

if me.cbbroker.value = true then
ws.cells(iRow, 7).Value = "Yes"
else
ws.cells(iRow, 7).Value = "No" 'or "" ????
End if

JeffK wrote:

I have a check box that's part of a form and have the information copy to a
data base:

ws.Cells(iRow, 2).Value = Me.txtMemberName.Value
ws.Cells(iRow, 5).Value = Me.TxtDeposits.Value
ws.Cells(iRow, 6).Value = Me.TxtLending.Value
ws.Cells(iRow, 7).Value = Me.CBBroker.Value <---this line
ws.Cells(iRow, 8).Value = Me.Txtmutualfunds.Value
ws.Cells(iRow, 10).Value = Me.txtComments.Value

The value that appears in the data base is "true" How do I simply change
this to say "Yes"

Thanks for your help

--

Dave Peterson