Coloured Squares

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
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
 
Mark said:
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)?
Click to expand...


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.
 
Back
Top