Hi wendy,
The macro will not start until [OK] button is clicked in the message
box.
So I think using an userform is better in your case.
Please have a look @ attached sample file.
Attachment filename: book1.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=401942
---
Message posted from
http://www.ExcelForum.com/