Thread: Loading images
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default Loading images

Hi Jason,

You can't concatenate object names like that. You'll have to do it with
three separate lines of code (or do something more complex, like set the Tag
properties of each image control, then loop the whole controls collection
and identify them by their Tag).

Game.Image1.Picture = LoadPicture("C:\....")
Game.Image2.Picture = LoadPicture("C:\....")
Game.Image3.Picture = LoadPicture("C:\....")

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Jason Morin" wrote in message
...
I'm loading pictures into Image1, Image2, Image3 on a
useform called "Game". Here's what I have:

For i = 1 To 3
Game.Image & i.Picture = LoadPicture("C:\....")
Next i

The "Image & i" is erroring. What's the correct syntax?
Thx.
Jason