Checkbox help

[Tony Miall]

Morning,

I have what I hope is a simple problem. I have jsut started working with user forms and have a text box called "DACustomer", when the checkbox called "BillingAddress" is ticked I want the contents of "DACustomer" to equal another text box on the same form called "Customer". I have tried...

Private Sub DACustomer_Change()
If BillingAddress.Value = True Then
       Me.Value = STDORDERFORMENTRY.Customer.Value
End If
End Sub

and a few other variations but can't get it to work. any help as usual appreciated.

 

[Tony Miall]

Please ignore this, all sorted