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)

On Fri, 2 Jan 2009 17:24:01 -0800, DDD
wrote:

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?