Quick question before I look further into this.
I've just been looking at this and I have it working in excell:
http://analystcave.com/excel-calcula...een-addresses/
Could this be adapted to work in access?
Thanks.
Quick question before I look further into this.
I've just been looking at this and I have it working in excell:
http://analystcave.com/excel-calcula...een-addresses/
Could this be adapted to work in access?
Thanks.
yes, the vb code can be put in an access vb module.
instead of feeding the function cell ranges, give it text box names.
txtResult = GetDuration (txtBoxSTart, txtBoxDest)
Thank you both, This should keep me busy for a while