Sounds like you are using stMessage to store the answer from the second
message box you talk about, as well as the original inputbox. Just use
another variable for that message box.

Jeff

"Noemi" wrote in message
...
Hi
I have an inputbox which stores the message in stMessage.

stMessage has bee put as a public sub so we can use the stMessage in other
sub's.

I have a cmd button which checks that all details are entered prior to
emailing the spreadsheet and if something is missing a msgbox appears
advising the user to enter information.

When this happens, the stMessage is wiped clean and we lose the message.

Is there a way to make sure that the stMessage doesn't change unless
advised
to do so.

Thanks
Noemi