Visual Basic

[DDD]

There are a number of tasks my spreadsheet has to do that may be too complex
to use macros on its own.

I have little experience with using VB, (Only thing i have made is a web
browser program, (not linked to excel))
---------- ------------------ -----------------
------------------- ----
Does anyone know how i could learn (e.g. website etc) how to use visual
basic, not just to make programs but to also use it with excel?

How did you first learn to use it?

 

[FSt1]

hi
this might get your started
http://www.contextures.com/xlvba01.html
http://www.mvps.org/dmcritchie/excel/getstarted.htm
http://www.rondebruin.nl/code.htm

there are a lot more out there on the net.
do a google on vb tutorials or similar.

Regards
FSt1

 

[JLGWhiz]

Check on Amazon.Com to see if they still have John Walkenbach's Excel VBA
Programming for Dummies on sale. I picked up a copy for about $17. It will
get you through the basics and then you can pick up other stuff from the web
and this site.

 

[Chip Pearson]

If you have Visual Basic version 6 (real VB, not VBA) at your
disposal, you can write a COM Add-In quite easily. See
http://www.cpearson.com/excel/CreatingCOMAddIn.aspx for details.
Writing an add-in in NET is much trickier (especially if you need to
support Office 2003 and Office 2007). For NET-based add-ins for
Office, I use the framework provided by Add-In Express
(www.add-in-express.com). It is a bit pricey, but it is much better
than Microsoft's model and well worth the cost if you're writing
commercial products (assuming you are familiar with VB.NET or C#).

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)