Coloured Squares

[Mark]

Hello,

I have a form on which I have lots of coloured squares.
Buttons on the sheet turn each square a different colour,
and by this I can remember which point I have reached in
a long sequence of processes I have to run on a monthly
basis.

Problem is, when I close down the form and re-open it,
the coloured squares have all returned to their original
colour.

Is there any way I can 'save' the colours the way they
are when the form is closed (or put into design view)?

I'm not the best coder so please go easy!...

Thank you,

Mark

 

[Terry]

Hello Mark,

One method is to store the colour values in the registry. In VBA help,
search on Registry and choose the SaveSettings method to see if it will do
the job for you. I have used this to provide users with a choice of form
colours specific to them. Note that saving settings in the registry is only
applicable to that machine.

Regards

 

[Marshall Barton]

I have a form on which I have lots of coloured squares.
Buttons on the sheet turn each square a different colour,
and by this I can remember which point I have reached in
a long sequence of processes I have to run on a monthly
basis.

Problem is, when I close down the form and re-open it,
the coloured squares have all returned to their original
colour.

Is there any way I can 'save' the colours the way they
are when the form is closed (or put into design view)?

You can't save the colors directly in the form, but you can
save one or maore values that determines the colors.

One way is to create a table to remember the colors and
restore the colors when the form opens.

Another possiblity is to check the data values when the form
loads and deduce the colors.