Take a snapshot of a userform

[kryptonian]

Hi,

I have a userform with text boxes, combo, boxes,etc and I want to take a snapshot of it so I can paste it in either outlook or lotus notes email. Basically, this should be like a printscreen function but should only get the image of the userform.

How do i do this in VBA, if possible? I will be using a command button to activate when to take the snapshot.

Thanks in advance!

 

[BrianExcel]

Hey guys, I was pointed in your direction for this topic and...

1. The code works AWESOME!!!!
2. I am trying to add one more step to this. Right now I have the code running and when I click the button on the page, first it calls your code to take the snapshot. NEXT it calls an 'email' sub which looks like this.

Sub Email()
    Dim OutApp As Object, OutMail As Object
    Dim Email As String, Center As String
    Dim FormImage As Image

    On Error GoTo Email_Error

    Email = frmCenterLookup.txtDevelopmentManager.Value
    Center = frmCenterLookup.txtCenterConfirm.Value

    Set rng = Nothing
    On Error Resume Next

    On Error GoTo 0

    With Application
        .EnableEvents = False
        .ScreenUpdating = False
    End With

    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)

    On Error Resume Next
    With OutMail
        .To = Email & "TEST"
        .Subject = "Center " & Center & " Inquiry"
        .HTMLBody =  [COLOR="Red"]<--- I want the copied snapshot here. [/COLOR]
        .Display

    End With
    On Error GoTo 0

    With Application
        .EnableEvents = True
        .ScreenUpdating = True
    End With

Email_Exit:
    Set OutMail = Nothing
    Set OutApp = Nothing

    On Error GoTo 0
    Exit Sub

Email_Error:

    MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure Email of Module EmailCode"
    Err.Clear
    GoTo Email_Exit

End Sub

What I would like to do, is paste the copied snapshot into the body of the email at the spot indicated above.

Can you help point me on how to do this?

 

[franklin08]

theres a lot you can do with this let me know if you need help.

whats above will only take a snapshot of the userform the button is on

so if you want it to do other things it should be w/ the same 3 lines of code. ie; automatically populate your email with it

What would be the code to export this just to notepad, or merely the clipboard as a text file formatted "copy" function? The end goal would be to paste in to JDEdwards which only uses a flat file formatted editing box.