Upon further searching, I guess the "real" solution is to upgrade to VB .NET and use LINQ.

Okay, one example was I had a long array of numbers, and I wanted to do a tally, where I calculated the frequency of each number occuring in the array. I also wanted the tally to be sorted with the...

There a lot of times in my program where I have large arrays of data and I would like to use the power of SQL commands (SUM, GROUP BY, INNER JOIN, ORDER BY) on this information. It is a great tool...

Disregard the extra 'Integer' declaration in my first post ... not sure how that got in there.

(I'm using VBA with Excel 2003, have references to OLE Automation and Microsoft Common Controls 6.0). The Hittest with my Treeview control does not seem to be working. I'm using it in a MouseDown...

I suppose that makes sense.

I suppose there are easy ways around it, as you mentioned. Even so, I find it surprising that VBA has this convenient feature, while full VB6 does not.

Most of my Visual Basic 6 experience comes from VBA with Excel. With VBExcel, you can run any procedure (if it does not require input parameters) by simply putting your cursor in the sub and...

Okay, thanks.

I guess then my question is what exactly constitutes "closing the form". I thought unloading meant clearing from memory, but as my above code demonstrated, my user-created properties of the form...

Thanks, I can see how it works now.

Is unloading a form variable in the code the same thing as setting it to Nothing?

Okay, I found something that works but I am still just as confused. In my parent sub I have a variable to the form. I also have given the form a public boolean variable, ConnSuccess, so it goes...

I have a routine that, at one step, calls a form and shows it modal. When the user closes the form the routine continues. However, upon closing the form I want to know if it performed its assigned...

Very interesting, I look forward to trying that out. It looks straightforward, but as it is all completely new terrain for me, might have to to wait for the next project to learn it. Deadline in...

Unfortunately the data is not in a UDT, but still another slick idea, thanks again. After this project is finished I am done with VB6 and moving to .NET or some other language, as the many gaps in...

Actually, now that I've read some stuff, I'm not sure this would fix my problem. It's my fault for not being more clear. Basically, at certain points in the code I need to create a copy of my...

Thanks so much for the suggestion. This could certainly help get me out of a jam. I have never serialized an object before though. I'm starting a web search but so far haven't found much (for...

I have created a class module, and my program creates many instances of the class. Each object has a lot of data, and I want to be able to create a new instance that is a copy of an existing...

And now I've learned that Visual Basic cannot do WithEvents for arrays of objects. Sometimes I really dislike this language.

That might solve that particular problem, but I was only using the deck of cards situation as an example of a general problem, not just unique names/keys. It is hard to think of commonplace...

That would work, but here is where I get some issues. Number 1, as you say, this checking routine is in the Parent Class. But, when you give a card a name, since that is a specific property of a...

As I learn class modules, one issue that seems to come up repeatedly involves class modules inside class modules - how the "child" class module can never see anything inside the "parent".

Say, for...

This involves an Excel file that is being controlled by another program. I have written my own excel file with vba that works with this Excel file. So basically, the program opens up an excel file,...

Anybody??

I'm actually having this problem with the Deactivate and QueryUnload events as well.

From my reading I think the Unload event is supposed to fire when you close a form with the close button or...

Thanks for the responses. I guess I understand that the Get and Let procedures serve specific purposes, and aren't supposed to be substitutes for procedures in general. I had already started making...

I'm new to class modules, and the compiler seems to be enforcing a correlation of the number of input vars for a Get and Let procedure of the same property. The Let property must always have exactly...

I want an embedded listbox (with headers) on my excel spreadsheet, that references a range on the worksheet. So using the ControlBox Toolbar I created a listbox. First thing I noticed is that there...

Yes the problem is solved (for now at least). I think I included too many details in my original post. I said arrays because the first class module I made were basically arrays with a few extra...

I think I figured it out. I made a property that is defined as one of the objects, then I set it to the specific element in the private array in the Get procedure. I'm new with classes and I didn't...

Thanks very much for the response! So far, collections seem to be the best alternative. One thing I have noticed is that the "intellisense" typing feature does not work as well with them, since the...

I am new to Visual Basic 6 Class Modules and am having difficulty constructing a certain class.

First off, I created a simple class, which is basically an array with some basic properties (Sum,...

Yeah, so it appears... I've pretty much resigned to finding workarounds. I really am not very fond of Excel charts.

The data columns and graph are on two different worksheets. I have tried explicitly naming the worksheets (which shouldn't make any difference) and other trivial syntax variations, but nothing works.

This is an issue that I've discusses many times before, but never with a conclusive solution. I am trying to programmatically change the data range for an existing chart in Excel. My code goes...

Is there a quick way to pass numerical arrays between two VB6 programs? Currently I am dumping the data from one program into an Access Db, then the other one reads it. However, speed is very...

I have an app in VB w/ Excel that uses the Microsoft Solver feature. In order to ensure functionality of the Solver I run the line: Application.Run ("Solver.xla!Auto_Open") when starting up the...

Part of the question was if anyone actually knew of any numerical solver programs (such as Matlab or Mathematica) out there that can interface with VB/Excel. I've read that SciLab might have some...

I'm writing an app in VB with an excel worksheet. At one point I need to solve a set of equations that are not explicit, so I need a numerical solver program. Excel's Solver is supposedly designed...

At one point in my program, if there is an error I need to show a customized form that allows the user to make necessary changes to some data. The code needs to be paused until the user is finished...