View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy[_5_] Doug Glancy[_5_] is offline
external usenet poster
 
Posts: 6
Default userform image from picture in worksheet

I've moved on from tic-tac-toe and am now creating a concentration game on a
userform. The form has a bunch of Image controls. I change the pictures
(.wmf) using the LoadPicture method. It works fine when I load the clip
from a file. However, I was hoping to store all the clips in the same
workbook as the form and load them from there. LoadPicture doesn't seem to
work, which makes sense. I then tried something like:

Image1.Picture = thisworkbook.worksheets("birds").shapes("birds1")

but if this is possible, I haven't found the right syntax.

I remembered John W.'s cut and paste method into the properties picture box
and that works, but I need to do it during runtime. I've read of, but
haven't tried, Stephen Bullen's clipboard method. I'll try that next but
first I thought I'd ask the group for any suggestions.

Thanks,

Doug