Thank you very much for your help!

The only problem is that I have to run the macro from inside of anothe
macro I have already created.

This macro (called Transfer) transfers data from Sheet 1 (InputForm) t
Sheet 3 (Records).

The validation macro has to be run before the macro that transfers th
data, and has to be excuted when the user clicks on the "Transfe
Booking Details" button on the InputForm worksheet.

How can I put the new code you have told me so that it runs before th
other macro?

(I have attached the file I am working on so you can see what I a
talking about!)

Thanks again

Attachment filename: oneblokesam.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=41607
--
Message posted from http://www.ExcelForum.com