You can not do what you are describing without storing the new value of the
caption somewhere. You can store it either in a cell somewhere, or in an INI
file (cell would be by far the easiest). When you initialize the form have
the label caption read from the cell.
--
HTH...

Jim Thomlinson


"Soniya" wrote:

Hi,

Is it possible to change label1.caption in my userform at run time and
save it without saving the workbook.

When I cahned the caption at run time and then closed the userform and
rerun the code again the caption again changes to the default.

Thanks