Form check box

J

JeffK

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
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top