0

I would be grateful if someone could tell me if I am declaring my arrays properly in my declaration statement so that they will be available in all of the macros and program.

With PowerPoint VBA my understanding is that if you want to access variables throughout the entire program then you declare them at the start (The Declaration). As far as I am aware this has worked perfectly with my non-array variables (e.g the integers), but unfortunately not for one particular set of arrays.

Below is my current declaration. For all of the non-arrays their values are retained when running different macros. However, the values of the TileAnswer() arrays have been lost when I try to access them in a different macro. I note that this macro has been called after the program user clicks a shape which has an action to activate the macro concerned. I note that the values go to zero as soon as this action has taken place. (No new code as been processed.) To confuse the matter further I have also used another set of arrays (shown as arraytest2) and they do not lose their values! I would be grateful for any advice or help as to what I should try!

Thank you!

Option Explicit
Dim Score, WrongClicks, StateofGame, ActiveRectangle1, ActiveRectangle2 As Integer
Dim TimeStart, TimeEnd As Date

Dim MyDocument As Slide
Dim oshp, oshp2 As Shape
Dim oeff As Effect
Dim oeff2 As Effect
Dim TileAnswer(16) As Integer
Dim arraytest2(2) As Integer
Alec Armstrong
  • 655
  • 1
  • 5
  • 10
  • You've run into a common mistake, declaring more than one variable causes the 2nd, 3rd etc to be Variants https://stackoverflow.com/a/34036529/495455. At some point you are ReDim'ing the TileAnswer. It could be going out of scope, unless the methods are in a different module, then you'd need to declare it `Public TileAnswer(16) as Integer` to make it a global variable. – Jeremy Thompson Jul 04 '20 at 02:48

1 Answers1

1

Thank you so much Jeremy Thompson - you helped you me quickly find my issue! What had happened was that I declared the array again in the first macro using another Dim TileAnswer(16) As Integer. I had used this code prior to finding out about using the declaration at the top of the coding (so had not thought about the need to remove this second Dim statement). Otherwise I am sorry if anyone finds my issue basic, but I am teaching myself PowerPoint VBA and am perhaps still in the early stages of learning it.

Thank you very much again! Alec Armstrong

Alec Armstrong
  • 655
  • 1
  • 5
  • 10