Because you have your .Show command before the .Hide command, you have an
instant where both forms active which causes a conflict between the two modal
forms. (You cannot Hide UserForm2 if UserForm1 has the focus, which it does
when you show it).

Another way to recitfy this would have been to reverse the order of the
commands, i.e.:
UserForm1.Hide
UserForm2.Show

--
- K Dales


"systematic" wrote:


Instead of another edit....I have now got this working properly by
running form2 as the modeless form. Would still dearly love an
explanation or a link to further info!

Thanks again.


--
systematic
------------------------------------------------------------------------
systematic's Profile: http://www.excelforum.com/member.php...o&userid=25294
View this thread: http://www.excelforum.com/showthread...hreadid=387984