Hi Guys
I have a multipage (3) userform(Usrfrm1) each page has 46 textboxes. On entry into a particular textbox on each page I want to launch another userform (Usrfrm2) which is a scripting dictionary that finally gives a unique code, on button click I want it to put the unique code into the multipage userform activetextbox.
Me.MultiPage1.Pages(Me.MultiPage1.Value).ActiveControl.Name
This gives me the textbox name of the activetextbox in the Multipage Userform...but
How do I get this value to be recognised in the other userform (Usrfrm2)?
I have a multipage (3) userform(Usrfrm1) each page has 46 textboxes. On entry into a particular textbox on each page I want to launch another userform (Usrfrm2) which is a scripting dictionary that finally gives a unique code, on button click I want it to put the unique code into the multipage userform activetextbox.
Me.MultiPage1.Pages(Me.MultiPage1.Value).ActiveControl.Name
This gives me the textbox name of the activetextbox in the Multipage Userform...but
How do I get this value to be recognised in the other userform (Usrfrm2)?