L
lux770
Hi,
I am trying to create a user form that toggles the spreadsheet vie
between the normal cells interior colors and colors that depend on th
cell content (e.g. yellow for a formula etc.)
I have created the form and the procedures that actually perform th
actions. My problem is that when loading the form, I want to store th
color of each cell of the UsedRange in an bi-dimensional array, so tha
I can restore the original colors of the spreadsheet (making sense s
far? )
That array needs to be public because I will need to use it in severa
procedures such as togglebutton1_change, userform_terminate etc
Therefore I have tried to delare it at the top of the form's code as
public variable.
Unfortunately I get the following message: "-Constants, fixed-lengt
strings, arrays, user-defined types, and Declare statements not allowe
as Public members of an object module-"
The VBA help suggests to "-use a set of Property procedures that accep
and return a Variant containing an array-", but I am afraid I have no
reach that level of competency yet. Could someone explain to me i
detail what I should do?
Many thanks
I am trying to create a user form that toggles the spreadsheet vie
between the normal cells interior colors and colors that depend on th
cell content (e.g. yellow for a formula etc.)
I have created the form and the procedures that actually perform th
actions. My problem is that when loading the form, I want to store th
color of each cell of the UsedRange in an bi-dimensional array, so tha
I can restore the original colors of the spreadsheet (making sense s
far? )
That array needs to be public because I will need to use it in severa
procedures such as togglebutton1_change, userform_terminate etc
Therefore I have tried to delare it at the top of the form's code as
public variable.
Unfortunately I get the following message: "-Constants, fixed-lengt
strings, arrays, user-defined types, and Declare statements not allowe
as Public members of an object module-"
The VBA help suggests to "-use a set of Property procedures that accep
and return a Variant containing an array-", but I am afraid I have no
reach that level of competency yet. Could someone explain to me i
detail what I should do?
Many thanks