There are as many ways to do this as there are programmers, times probably
five.  One way would be to expose a String property from each UserForm, and
read it from the first then assign it to the second.  I'd recommend
(heartily) against using a global variable, but there's the least painful
(though ultimately most expensive) method.