multiple userforms problems

[scott micklo]

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.

Unload UserForm1
 '   *************************************************************************************************************
 
  ' dcdone = False        ' boolean catcher for if ll down codes inpout
 
 'Do                     '  loop to get all down codes
 
    ' prefill data
    UserForm2.txtpn2.Value = Worksheets("Daily Run Data").Cells(nr, pnc).Value
    UserForm2.txtdescrip2.Value = desc
    UserForm2.txtdt2.Value = UserForm1.txtdt.Value
    UserForm2.txtline2.Value = ml
    
    
  Load UserForm2         ' imput screen for downtime codes
    
    
    
    Unload UserForm2

'Loop Until dcdone = True            '  no more down codes to input

[Norie]

If your userforms are modal it doesn't prevent one reading from the other.

You probably want to hide the one you are reading from, read the data from it to the other form and then unload the first form when you are finished with it.

[scott micklo]

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

[scott micklo]

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.

[Norie]

Scott

Are you still unloading the first userform?

Where is the posted code located and how is it being executed?

[scott micklo]

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.

[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.

[scott micklo]

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
????

[Norie]

Not quite, you don't want to unload userform2.

1 Hide userform1.

2 Load userform2.

3 Transfer data from userform1 to userform2.

4 Unload userform1.

5 Show userform2.

[scott micklo]

THANK YOU VERY MUCH!!!

Got it working and learned in the process.

Thanks again!!!!!