Looking for VBA reference material

[Babillon]

Hello. I'm working on a project for work, in which I need to sort some information in Excel. I've decided that VBA would be the best way to approach this problem, and am having a difficult time finding a full set of language specifications.

If anyone has a good link to an article showing all of the language features of VBA (I'm mostly interested in how close to VB.NET VBA is, I'm wanting to use Structures), I would be very much appreciative.

Thank you.

 

[SkipVought]

Hi,

http://www.microsoft.com

VBA HELP

Numerous books. I like Walkenbach.

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[Babillon]

I've searched through the MSDN to the best of my ability, however I have not been able to find any articles pertaining to the actual language semantics. Mostly what I need to know is how similar to VB.NET is VBA? Do I have access to the same looping and condition structures? What about data types? Am I able to create Structures, Enumerations, etc?

 

[Bong]

Have you looked at the VBA reference and Excel reference under the VBE help? After figuring out what's where, I find that to be the most useful language reference material.

_________________
Bob Rashkin

 

[Babillon]

Unfortunatly the Excel help files weren't installed on the machines. I actually ended up finding out that you can indeed use Structures in VBA, thanks to dailydoseofexcel.com (very good resource).

It doesn't help that I'm not in an actual programming position at my company and had to use up the supervisor's computer for roughly six hours of the day to work on this project.

But thank you all for the help!

 

[fumei]

If the Help files are not installed you may have a problem. Get them installed.

Gerry