Code to transfer userform info to worksheet

Thanks for the speedy reply Dave.
I'm attaching the file alongwith.
It is basically a Pilot logbook for getting various data together and thereafter collating them for other output.
I have prepared the stuff with a lot of help from the internet and very largely from your site albeit. :-)
I am presently working on the frmutilitytool userform.
Thanks a ton in advance.

One other request. On the DATA sheet in column 'G' are the names of various airfields and their ICAO designators in column 'F', Is it possible for the user to select an airfield from the list on the form and when he moves away to another box for it to show the ICAO designator instead of the selection? Trial VBA for Logbook big.xlsm

N.B: You might find the code very novice-like as I have never worked on vba before, but am trying to use it and have discovered that it can be a very powerful tool.
When you open the sheet go to any other sheet and then back to sheet one for the code to work the way i plan to have it open. Thanks again. and sorry for the bother.

Oh and Dave I was using the Submit Test button on the RHS Page to test code working or not before transferring it under the submit command button.

Hey Dave Thanks.

I guess It must have happened cause i had worked out a formula on column 'U' to give a blank instead of value zero (numeral zero). I'll amend that.

Thanks a ton Dave. You Rock!!