Solved

UDT and OCX

Posted on 2002-07-05
3
219 Views
Last Modified: 2010-05-02
how do you pass a User Defined Type variable through an event or through a public function. I would prefer not to have to use lset on both sides but if I have to I have to.
0
Comment
Question by:sk33v3
3 Comments
 
LVL 32

Expert Comment

by:bhess1
ID: 7132548
I assume that you are using Classes here.  A UDT can not be passed through a Public Class interface.  Instead, you must use Friend properties and methods to pass UDTs.

0
 
LVL 15

Accepted Solution

by:
ameba earned 50 total points
ID: 7132700
You put UDT declaration into class module, and class must be Public (e.g. Instancing = 2 'PublicNotCreatable)
0
 
LVL 9

Author Comment

by:sk33v3
ID: 7132990
Worked like a charm
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now