PDA

View Full Version : Shape Fill by Clipboard



Tiger Chen
08-30-2011, 02:53 AM
In Excel 2007, we can do this manually:
step 1. select a picture and copy it
step 2. select a Shape - format shape - fill - picture or texture fill, and click "Clipboard"

the Shape will be filled by the picture.

How can i do it in VBA?

thanks a lot in advance!

Aussiebear
08-30-2011, 03:38 PM
Try recording the steps using the macro recorder, then if you have an issue with the code, post it here for assistance