object array in excel

  • Thread starter Thread starter OzziePete
  • Start date Start date
O

OzziePete

I have created a form with 16 different images (Footy team Gfx)
How do I address these graphics on both other forms and worksheets
using for next loops, I have named the images Logo_01, Logo_02....etc
I am currently working around this with huge chunks of Select Case Code
 
Name the pictures the same as the team name. The code below will put each
picture in column b along side the Team Name

Range("A1") = "Footy team Gfx"
Range("A2") = "Footy team Gfy"
Range("A3") = "Footy team Gfz"

For RowCount = 1 To 3
TeamName = Range("A" & RowCount)
Set MyPict = ActiveSheet.Pictures(TeamName)
MyPict.Top = Range("B" & RowCount).Top
MyPict.Left = Range("B" & RowCount).Left
Next RowCount
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use Loop to set Picture Property of image on User Form 1
Finding the maximum in an array of strings (Excel VBA) 6
Arrays problem in new filtering code 3
Cell values to an array, then array transpose to another workbook 8
Converting a Graphics object to bitmap - please help! 5
Paste cross section of 3D array in one step 6
execution speed issue when closing files 5
Set Array equal to Range 6

Back
Top