PivotArea.Format.Fill with picture from Clipboard

[JSSWAT]

Hey all,

After about an hour of searching I am stumped. Excel 2007 has a nice feature that when you select the plot area of a chart, right click, select Format Plot Area..., then select the Fill tab and select the "Picture or Text Fill" radio button, you have the option to hit a button and insert the image from the clipboard.

Now when I record this action with the Macro recorder it seems to stop recording as soon as I select the plot area. Being somewhat experienced in chart formatting I know you can select a fill image from a file like so:

ActiveChart.PlotArea.Format.Fill.UserPicture "C:/..........."

My question is basically can I do some sort of call to the clipboard:

ActiveChart.PlotArea.Format.Fill.UserPicture = CLIPBOARD PLEASE!!!

^That did not work by the way...

I am happy to get more complicated but praying this one is simple.

Thanks,

Joe​

 

[JSSWAT]

Ok tried a couple more things. I can Dim a variable as a Picture:

Dim Background as Picture

I have seen some people use something called GetFromClipboard. Not sure but I am assuming this is available through some Reference Library or something. Just fuzzy on the details.

Thanks in advance for any help.

Joe