One of the most important thing in working with spreadsheets is knowing
when to quit! Having said that, if you change the line in the 'original
code' from

If Err = 0 Then

to

If Err = 0 And Len(rText.Cells(1).Value) < 0 Then

your users won't see the code stop for empty textboxes and therefore
they won't have to click OK in for those textboxes.

Now I'm going to put down the keyboard and back slowly away - and maybe
I won't compulsively make any more 'enhancements'... :Bgr


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=120599