Greetings,

I have a userform that changes the contents of the highlighted cell. I have
a message box routine which confirms that the desired cell is highlighted
(so we don't work on the wrong cell). At times, this gets laborous. What I
would like to do is add a checkbox to the userform. Then when you open the
workbook and run the userform you would go through the cell confirmation
question. Then, when the userform pops up, if you don't want to go through
the cell confirmation, you would check the checkbox. Once the checkbox is
checked, the programming would remember this until you uncheck the checkbox
or close the workbook.

I can do all of the programming, however, I need an easy way to have the
programming remember whether the checkbox is checked, and initially start
unchecked.

Any ideas on how to do this. In other languages there were volatile memory
variables which remained available until the program was shutdown. It
appears that these exist in VB, however, they only last while a module is
running.

Thanks for helping me understand!!

Ray