asked on
Private Sub UserForm_Activate()
Form_Personalized = FindWindowA(vbNullString, Me.Caption)
STYLE = StartWindow(Form_Personalized, STYLE_CURRENT)
STYLE = STYLE Or WS_CX_MINIMIZAR
STYLE = STYLE Or WS_CX_MIXIMIZAR
MoveWindow Form_Personalized, STYLE_CURRENT, (STYLE)
End Sub
Within module "SendEmail" the following code is included:Answer = MsgBox("Do you wish to check report details before producing email and attachment?", vbYesNo, "Mailbox Check")
If Answer = vbYes Then
frmSendEmail.Show
Exit Sub
Else
End If
When the above code is executed, it does result with the display of the frmSendEmail but the form that is displayed does not include the display of the Maximize and Minimize functions on the userform which would be included if the Private Sub UserForm_Activate() was executed when the frmSendEmail.show is ran.ASKER
ASKER
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
TRUSTED BY
Put a breakpoint on line 2 of the UserForm_Activate code. You do that by clicking in the left-hand margin of that line. Then execute your SendEmail code. Does the code stop at the breakpoint?
For more information about debugging, please see my article on the subject.