Changing object properties permanently at runtime

[Darv]

Hi,

I'm having trouble changing the properties of objects permanently at
runtime. Specifically, I am trying to make a commandbutton visible at
runtime. This works fine, but when I reset the VBA code, the
commandbutton returns to it's state prior to running the code.

Thanks for any help anyone can give.

David

 

[NickHK]

David,
Yes, that is the difference in meaning between "Design Time" and "Run Time".
If you want a property to be set for the next time you open that workbook,
you need to change it the Design time.

NickHK

 

[Darv]

Hi Nick,

I understand that, but is it possible to change a design time property
at runtime?

David

 

[Peter T]

Hi David,

Sub Test()
Dim dForm As UserForm

Set dForm = ThisWorkbook.VBProject.VBComponents("Userform1").Designer
dForm.CommandButton2.Caption = Time

End Sub

You can't do this while Userform1 is loaded (AFAIK). Can also add/delete
controls.

(You'll need trust access to vb projects in xl2002+)

Regards,
Peter T

 

[Darv]

Perfect thanks!

Hi David,

Sub Test()
Dim dForm As UserForm

Set dForm = ThisWorkbook.VBProject.VBComponents("Userform1").Designer
dForm.CommandButton2.Caption = Time

End Sub

You can't do this while Userform1 is loaded (AFAIK). Can also add/delete
controls.

(You'll need trust access to vb projects in xl2002+)

Regards,
Peter T