multiple userforms problems

hi experts

I have a program that loads a userform for input of data, it takes the data, crunches it and displays it on a sheet --- its not elegant and i believe its way too long and can be done a lot cleaner. BUT -- that is another issue for another day.

My issue right now is this -- from Userform1, I need to have another userform (call it Userform2) load to accept data and determine the time lapse, accept the down codes, and move on and display it. My problem at hand is that I can get Userform2 to load, but can not get it to prefill the textboxes. I have tried reading the data from Userform1 into Userform 2 -- found out userforms are modal and can not do that. So I tried to read it from either variables or from the sheets they were put in . But nothing is working.

I am unsure what my problem is.

I can not attach my program as its too large. I am however, putting the code in this window that is relevant. Again I realize that this is long and can be much much cleaner -- but right now I need to get this running .

Is it an issue of having 2 userforms open at once? I can get Userform2 to load up, but thats all.


Thanks in advance for assistance.

Please Login or Register  to view this content.

I have "showModal" set to FALSE. Is this correct?

OK. SO I have the showModal set back to TRUE, and I am getting the userform2 to load.

But, It is not prefilling the data as in the code above. I have run this with msgbox to check and data is all there.

Is there something that i am missing in my code or a setting to prefill the userform2 with the data? I ihave checks and textbox names are all matching, and my code is exactly like my code earlier in my program where I prefill userform1.

Yes. I am unloading userform1 before attempting to prefill userform2.

The code/program is 35mb, too large to attach.

The snippet of code is in the main post above.

Originally Posted by Norie

Like I said in my first post, you don't unload the first userform.

Hide it, get the data from it and then unload it.

OK. I think I was getting confused with unload and hide.

So code wise,
Userform1. hide
prefill userfrom2
unload userform 2
unload userform1
????

THANK YOU VERY MUCH!!!

Got it working and learned in the process.

Thanks again!!!!!