Picture in a dialog box for Excel

[dkw]

Hi there,

I'm new to VBA and am stuck in Excel trying to insert an existing chart into a custom dialog box in a DialogSheet. I want to insert it as a picture so users can see it but not do anything with it. One way that sort of worked is just

Workbooks(ref).Worksheets("Charts").ChartObjects(1).Copy
Workbooks(ref).DialogSheets("plot").PasteSpecial

Problem is that then I seem to have no control over the size of the picture, or where it appears in the dialog box.

Any assistance with either a better way of getting the picture into the dialog sheet, or with simply controlling the size and position, is much appreciated

David.

[BrianB]

Try Alt + PrintScreen keys to put the image on the clipboard then paste into a picture application like MS Paint. Save as .bmp file or whatever.

In the dialog box use the image tool.