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

 

[Andrew]

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.

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

 

[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)