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