VB Classes In VBA

Dec 23, 2008

I'd like to create a number of classes in a VB.NET DLL and then use them from VBA in Excel 2003+. Is this possible? I wouldn't actually expose any of .NET. These would be simply be classes defined by me (which may wrap elements of .NET but never require VBA to have knowledge of .NET or access to .NET assemblies).

If this is not possible, would it be possible to create a DLL in VB.NET that exports functions and subroutines that can then be linked into VBA by importing them (the same way you would with Win32 API routines)?

View 3 Replies


ADVERTISEMENT

MS Training/classes

Sep 21, 2008

I am interested to get some opinions/input on where one might obtain Excel training/classes, etc. Our local college infrequently offers classes and when they do, the class is most always entry level which I have already taken. Online or correspondence would be acceptable.

View 2 Replies View Related

Declare Variables In Classes?

Apr 14, 2014

Why it seems not possible to declare variables in Class modules like so:

[Code] ....

View 3 Replies View Related

Using Classes In Multiple Projects

Sep 22, 2008

I am trying to replicate the class example on Chip Pearson's site:

[url]

In particular I am interested in having a class that can be accessed by multiple workbooks.

View 12 Replies View Related

350 People Tracking 24 Dates For Classes Each

Feb 20, 2009

I have a spreadsheet with ~350 people tracking 24 dates for classes each. On a seperate tab I have a macro that copies and pastes a pre-defined macro to display the due dates. My question is, can I have a macro run the calculation and put the result in the cell rather than have around 8,400 calculations on a sheet?

View 9 Replies View Related

Raise Event From One Of Custom Classes Instead Of Calling Sub?

May 2, 2014

I can create events in my custom classes. When do I even want to raise an event like this instead of calling the corresponding Sub?

I imagine that I can create an event called OnColorChange or I can create a sub called OnColorChange.

Why would I want to create an event?

View 1 Replies View Related

Enter & Exit Events In Control Classes

May 11, 2006

A lot of people seem to have been having troubles with the fact that if you try to use controls in a class with the "withevents" keyword, some events (like Enter & Exit) are not included in the tracked events. I have been having some troubles with this myself & have not yet seen any particularly satisfying workarounds to this problem.

So here is an idea I just had, I have not made any attempt yet to implement it & so have no idea how complicated doing so would be, but I thought I would just put it out here & get some feedback on the idea before I spend any real time working on it.

The idea is to create a blank, transparent label that covers the entire form, monitor the Click event of this label, & pass it back to the normal controls on the form as necessary. Does this sound doable, or do you all think it would be merely an exercise in futility? If anyone has any better suggestions for how to work around this lack of events,

View 4 Replies View Related

Count Number Classes Taught For Each Column Heading Name

Mar 12, 2007

This is a double IF() to me. I just can't figure it out.

I download a list of classes taught by a number of teachers. I want to summarize how many of classes taught by each teacher.

I have tried many variations of countif() but can't seem to figure out how to do both.
Example copied in below:

ClassesTeacher Classes Taught Angela Barbara Bob
mathAngela math 2 0 1
englishBarbara english 0 2 0
musicBob music 1 0 1
mathBob
englishBarbara
musicAngela
mathAngela
englishAngela
musicBarbara
mathBob
englishBarbara
musicAngela
mathAngela
englishBarbara

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved