Changing an array on a sheet from a form

[zedutch17]

How can I define an array in a sheet so that I can change it through a form.

For example, I have typing this in the code for the sheet:

Dim MyFormsShown(18) As Boolean

And this in the code for the form:

If event occurs Then
Sheet1.MyFormsShown(2) = False
End If

This did not work..
Thanks for any help,
Eric

 

[combo]

You need a public variable, however vba will not allow to declare array in sheet's module. Declare it in a standard module instead (or try public in sheet's module and follow hints in help file when you try to debug the code).

combo