I have a project wherein I need to cast an object as a Control. Unfortunately, I can't seem to get CType to work in VBA. Does VBA support the CType keyword, and if does, what specific references need to be set the project.

Thanks in Advance

Unfortunately VBA doesn't support type casting. It isn't a fully object-oriented language. You can neither inherit classes in your own custom class definitions, nor can you get your objects to behave polymorphically (e.g., cast them as an instance of their base class). VB6 doesn't support inheritance/polymorphism either, but VB.NET and C# do.

HTH,

Bob

what is VB6??


upama

VB6 was Microsoft’s primary, high-level, Windows application development language and platform. About 3 million developers in the U.S. alone use it. Microsoft recently decided to discontinue development and support for it, however, and VB.NET (which is completely unlike VB6, ‘cept for the “V” and the “B”) and C# are Microsoft’s current, primary, high-level, Windows application development languages.

Bob

 

Should have said VB6 doesn't support implementation inheritance (which is why it doesn't support polymorphism either). It does, however, support interface inheritance (but by definition interfaces define empty members - methods, properties, etc. - and don't contain any member implementations). NET does all this stuff.

Bob

If you want to find a control in the current sheet in excel for example named "MyLabel" and set it's image property to a file located on "C:\Images\Image1.jpg"
you can yuse the following code

==================================
Dim lbl As MSForms.Label
Set lbl = Me.OLEObjects("MyLabel").Object
lbl.Picture = LoadPicture("C:\Images\Image1.jpg")
===================================