Problems with VBComponent Properties

Joined
Feb 28, 2011
Messages
2
Reaction score
0
Hi Everybody! This is my first post here and I am keen in leraning more and share my expertise as well....

My question probably is quite easy but I spent all day yesterday working on it trying to find a solution but with no success!

This is where I am having problems:

Dim cld_edt, country as String
Dim obj_cld as Object
etc....
etc....

Set obj_cld = ThisWorkbook.VBProject.VBComponents(cld_edt)
With obj_cld.Properties
.Caption = CStr(country) & " - Campaign Period"
End With

Basicaly the code sets a new object (already created) via a string (cld_edt) and then try to change the caption.

The message error I am receiving as an answer is "Method 'Properties' of object '_VBComponent' failed"

I think that the set is not an issue, but if I try for example to show the form I receive the same error...

Anyone can help me??

Thanks a lot in advance! Hope to share knowledge here!

Rodrigo
 
Back
Top