Try something like

With ThisWorkbook.VBProject.VBComponents("UserForm1").D esigner
.Controls("Label1").Caption = "new text"
End With

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Wed, 11 Mar 2009 13:36:01 -0700, Howard31
wrote:

Hi all,

Can anyone tell me, how I can change the caption of an EXISTING label in a
userform, in runtime, using the Designer object, so that the caption is saved
even after the userform is unloaded?