View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Darren Hill[_2_] Darren Hill[_2_] is offline
external usenet poster
 
Posts: 80
Default userform image from picture in worksheet

Could you have all pictures set up in design time, but set their Visible
properties to False. Then when you need them, set Visible to True and move
them to where you need them?
--
Darren
"Doug Glancy" wrote in message
...
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