Jenn wrote:
Hello,

This is executed from a module, public sub, mainform is the userform
where textbox1 is. When this code is executed the message box works
correctly, but when you hit ok the program does not continue, instead
it pops out of "run" mode into "design" mode. This is data validation
code which i need, I have very similar code running in the userform
sub, so I am assuming it has something to with being a called
procedure running from a module? Any help would be greatly
appreciated, thanks.

Jennifer

The use of 'End' is a bit drastic. Try using 'Exit Sub' instead to see if
that works better.

--
Regards,

Juan Pablo González