Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading images
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading images
Jason,
Try this: Game.Controls("Image" & i).Picture = LoadPicture("C:\....") hth, Doug Glancy "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading images
What I do is this:
For i = 1 to 3 Game.Controls("Image" & i).Object.Picture = LoadPicture("C:\...") Next i -- Regards, Juan Pablo González "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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading images
Thanks! That did the trick.
-----Original Message----- Jason, Try this: Game.Controls("Image" & i).Picture = LoadPicture ("C:\....") hth, Doug Glancy "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 . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading images
Gracias. Ahora funciona perfectamente.
-----Original Message----- What I do is this: For i = 1 to 3 Game.Controls("Image" & i).Object.Picture = LoadPicture("C:\...") Next i -- Regards, Juan Pablo González "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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loading add ins | Excel Discussion (Misc queries) | |||
Chart.Export images are shrinking as I export more images | Charts and Charting in Excel | |||
Loading... | Excel Discussion (Misc queries) | |||
loading | Excel Discussion (Misc queries) | |||
Add-ins not loading | Excel Discussion (Misc queries) |