To get a value from a form's control, use
[vba]
Range("B71").Value PandL2.Interest1.Value*.01
[/vba]
but the form will still need to be loaded, otherwise it fails.
To get a value from a form's control, use
[vba]
Range("B71").Value PandL2.Interest1.Value*.01
[/vba]
but the form will still need to be loaded, otherwise it fails.