- 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
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