getting Array Value within a User Form on a Button Click

[lonely]

Hi All,
I am working on a small VBA for PowerPoint.
I am trying to call the value of a array within a user form when a person clikc on a button. The code I am using is as shown below:

Public Sub MyButton_Click()
On Error Resume Next
With ActiveWindow.View.Slide.Tags
    .Add Name:="MYTAG", Value:= TagsArray(1)
End With
End Sub

However, when I compile the project, I get an error saying TagsArray function has not been defined. Please can someone help me with this?
Thanks,
Lonely

 

[NateO]

Hello,

Where is the array declared? Is it public and in scope?

 

[lonely]

Hi,
Thanks for the reply. The array is declared on the form initialize event. And althoguh it was Private earlier, i changed it to Public to see if it makes any difference.

 

[NateO]

Hello again,

Declared or populated?

It can't be declared in a Form, delcare it publicly in a normal module. Now all modules across your project can see it.

Here's an example, all in a normal module:

Public myArr(0 To 1) As String

Sub testStck()
Let myArr(0) = "Test"
End Sub

Sub test()
MsgBox myArr(0)
End Sub

 

[lonely]

Resolved!

Thanks a Lot NateO,
That helped me a lot...now i understand Arrays better.
Have a wonderful day!