View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Copy each control & rename

Images are loaded into an image control. They aren't copied and pasted.

Image1.Picture = LoadPicture("C:\Windows\Desktop\hi.bmp")

You can build your file name as part of the string argument to LoadPicture

--
Regards,
Tom Ogilvy

"Jason Morin" wrote in message
...
Not sure why "copy" is not an offered method for controls.
Anyhow, I'm trying to copy and paste a group of images on
my userform (destination is not important right now) and
have them renamed. Each image name begins with "d1_". I
simply need to copy and paste each image - the only thing
that will change is that I need replace the first 3 char.
of the name (for example, from "d1_7777" to "d2_7777").

Thx.
Jason