Setting a label value on a userform dirties the spreadsheet

[barbararyan]

In a userform, I am populating the caption of a label (via code). This causes the userform/spreadsheet to be "dirtied", causing the "Do you want to save changes?" dialog box to appear.

How can I prevent this?

Thanks!
Barb

[dominicb]

Good afternoon barbararyan

causing the "Do you want to save changes?" dialog box to appear.
How can I prevent this?

Use this line somewhere prior to the code that closes the wroksheet. It should suppress the warning :

Please Login or Register  to view this content.

HTH

DominicB

[barbararyan]

Thanks, Dominic... this will work but, if the USER has made changes, I do NOT want to suppress the message. Basically, I want to prevent the form from being "dirtied" when the label caption is populated.

Thanks,
Barb

[dominicb]

Hi barbararyan

I don't understand what you mean. Could you explain what you are doing / trying to do and what you mean by the form being "dirtied"?

DominicB