UserForm vbModeless issue

[SQUIDD]

Good Evening.

So, I have a userform called JOB_FINANCIALS
When i click an image on another userform(JOB_INFO), JOB_FINANCIALS loads on the screen.
on UserForm_Activate it performs a series of calculations from both the sheet and previous user form and displays the results in various textboxes.

However, i have a save button on the previous userform(JOB_INFO), this saves info to a central database.
But i need those calcualations as well as other info to save.

My thought process was

JOB_FINANCIALS.show vbModeless
grab the data and store it as temp variables
Unload JOB_FINANCIALS
use the saved variables when i hit save.

Problem is, the data does not arrive in the user form when i use JOB_FINANCIALS.show vbModeless, only if i use JOB_FINANCIALS.show

but i cannot execute any code until i close the userform using JOB_FINANCIALS.show, and by then the data has gone lol

i do not want a 2 step saving process.

I'm stumped

thanks for reading, hope you understand

Dave

 

[SQUIDD]

Hi All

Yeah, so i had a bit of a stupid moment here.

I have just stored the variables on the userform_terminate

[CODE=vba]
JOB_FINANCIALS.show vbModeless
DoEvents
Unload JOB_FINANCIALS

Private Sub UserForm_Terminate()
MsgBox Me.TOTAL_QUOTE
End Sub

[/CODE]

so that sorts it out

thanks

Dave