Might I suggest you modify the design?

You say that you need to run this new macro from within transfer. My
question, is why? If you do it there, the invalid data will already have
been created, and all you are doing is forcing them to go back after they
think they have finished. Not good design.

My solution checks the data as it is input and stops invalid data being
entered. Therefore, when they hit the transfer button, you can be assured
the data is valid, and so you don't need to test for it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"princess " wrote in message
...
Thank you very much for your help!

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

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

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

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

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

Thanks again!

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