Prev: determine how excel was opened
Next: extract data from .ora file
From: JeffK on 29 Mar 2010 16:38
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
From: Dave Peterson on 29 Mar 2010 17:40
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
 | 
Pages: 1
Prev: determine how excel was opened
Next: extract data from .ora file