Check box VBA

Mitt1

Registered User.
Local time
Yesterday, 21:32
Joined
Apr 20, 2016
Messages
19
Hello please have a look at this image:
When the checkbox is clicked I would like to make the trading address info (in business details) appear in the account address info.
Does anyone know any VBA to do this?
 

Attachments

  • 9ccce9ff2ebb88dd84c0bc4b704cc93a.png
    9ccce9ff2ebb88dd84c0bc4b704cc93a.png
    26.3 KB · Views: 113
Code:
Sub chkBox_Afterupdate()
If chkBox.value then
   TxtAddr2= txtAddr1
    TxtCity2= txtCity1
Else
    TxtAddr2= ""
    TxtCity2= ""
End if
End sub
 

Users who are viewing this thread

Back
Top Bottom