M Mitt1 Registered User. Local time Yesterday, 21:32 Joined Apr 20, 2016 Messages 19 Nov 13, 2016 #1 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 26.3 KB · Views: 113
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?
Ranman256 Well-known member Local time Today, 00:32 Joined Apr 9, 2015 Messages 4,348 Nov 13, 2016 #2 Code: Sub chkBox_Afterupdate() If chkBox.value then TxtAddr2= txtAddr1 TxtCity2= txtCity1 Else TxtAddr2= "" TxtCity2= "" End if End sub
Code: Sub chkBox_Afterupdate() If chkBox.value then TxtAddr2= txtAddr1 TxtCity2= txtCity1 Else TxtAddr2= "" TxtCity2= "" End if End sub