Visual Basic
 

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?

Visual Basic
 

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

"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?

Visual Basic
 

Create macro's in excel - then edit them to suit your needs.
A great way to get the basics.. And the helpfiles are useful
(Sometimes)
HTH
A.

"FSt1" wrote in message
...
| 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
|
| "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?
|

Visual Basic
 

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.

"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?

Visual Basic
 

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?