Thread: Object Arrays
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phantom Phantom is offline
external usenet poster
 
Posts: 7
Default Object Arrays

Hi ~

I've been racking my brain on this for over an hour. I want to create
a dynamic object array that will save the caption and faceid to an
assigned array. It seems pretty straight forward, but I can't seem to
figure it out. Here's a sample of my code:
Dim myObject As Object
for x = 1 to 2
Select Case Level
Case 1
myObject.Caption = "aaaa"
myObject.FaceId = 321
Case 2
myObject.Caption = "bbbb"
myObject.FaceId = 423
End Select
If you can provide any help on this, I would greatly appreciate it.

Thanks,

Denny.