Hey team,

So I'm working on a document that is created from a userform.

In creating the letter head portion, I currently do this...

GRAPHIMAGE_LOGO = "C:\Users\OEM\Documents\Form_Set\letterhead.png"
.Cell(1, 1).Range.InlineShapes.AddPicture FileName:=GRAPHIMAGE_LOGO, LinkToFile:=False, SaveWithDocument:=True

What I would really like is to have a hidden userform with picture controls in it that hold my images, so I can then grab said image from the userform and fling it into the cell in the document table.

GRAPHIMAGE_LOGO = UserForm999.letterhead.Picture
.Cell(1, 1). [insert amazing code here please]

Thanks in advance.


Regards
Kes