Thanks ever so much Chip, for responding.

I have tried just this, the problem is that I get a runtie error message -
"Object variable or With block variable not set"

This is the code copied and pasted from the VBE:

With ThisWorkbook.VBProject.VBComponents("UFPwd").Desig ner
.Controls("LblPwd").Caption = "NewPassword"
End With

As I'm already writing to you, can I ask whether it is possible to customize
the Ribbon in Excel 2007 via VBA?


--
A. Ch. Eirinberg


"Chip Pearson" wrote:

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?