|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Apr 15th, 2002, 09:00 AM
|
#1 |
|
New Member
Join Date: Apr 2002
Posts: 17
|
Hi all, I am a college student and need to learn Visual Basic for a project I will be doing. I have quite a bit of time to learn it, about a quarter, and was wondering what books/websites the experts would recommend. Thanks for your help!!
|
|
|
|
Apr 15th, 2002, 09:04 AM
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Columbus, OH, USA
Posts: 3,519
|
I would recommend this website for one and this website:
http://www.bmsltd.co.uk/Excel/Default.htm For some harder stuff. As for books, here is a list of books: http://www.mrexcel.com/book.shtml I would recommend "Excel 2002 VBA Programmers Reference" from this list. I loved the 2000 version of this book but MrExcel himself tells me that the 2000 book is crap (I'm paraphrasing), but the 2002 is very good indeed. |
|
|
|
|
Apr 15th, 2002, 09:46 AM
|
#3 |
|
Board Regular
Join Date: Mar 2002
Posts: 363
|
If you're looking to learn VB and not necessarily VBA I would highly recommend "Learn to Program with Visual Basic" and "Learn to Program Visual Basic Objects" by John Smiley.
He uses a real world project to take you through the learning process in a classroom environment. The second book is a continuation of the first.
__________________
It's never too late to learn something new. Ricky |
|
|
|
|
Apr 15th, 2002, 09:52 AM
|
#4 |
|
New Member
Join Date: Apr 2002
Posts: 17
|
Thanks guys... I am actually trying to learn VBA, I will be doing some linear programming and my prof wants me to use excel and VBA.
|
|
|
|
|
Apr 15th, 2002, 09:56 AM
|
#5 |
|
Board Regular
Join Date: Feb 2002
Location: Sutton Coldfield
Posts: 1,143
|
Danny,
Wen I started, I found a really useful reference book was Excel 2000 VBA by John Green, published by Wrox Press. Has loads of Code examples and useful reference tables. Will. |
|
|
|
|
Apr 15th, 2002, 10:02 AM
|
#6 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Columbus, OH, USA
Posts: 3,519
|
WillR, that's the book I recommend as well. I'm glad you agree. (Although apparently the 2002 version is far superior)
|
|
|
|
|
Apr 15th, 2002, 11:39 AM
|
#7 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,064
|
easy free and excellent stuff:
suggest checking some of the guys on this sites own web site, check out membership and filter on posts most the top guys have own site, I an in top 10 sadly no site sorry.. also stick on this site, very good learning join in the fun!
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
Apr 15th, 2002, 11:46 AM
|
#8 |
|
Board Regular
Join Date: Feb 2002
Location: Tulsa, OK
Posts: 354
|
http://msdn.microsoft.com/library/de...mmersguide.asp
If you click on MicorSoft Office you can find VB for each individual program (Excel, Access....) It's a place to start, I think... |
|
|
|
|
Apr 15th, 2002, 11:17 PM
|
#9 |
|
New Member
Join Date: Apr 2002
Posts: 17
|
What exactly is the difference between VB and VBA?? Which would be more useful for me to learn??
|
|
|
|
|
Apr 15th, 2002, 11:40 PM
|
#10 |
|
Board Regular
Join Date: Mar 2002
Posts: 363
|
VB is Visual Basic which can be used to make stand alone application.
VBA is Visual Basic for Application which can be used to exploit the features of applications such as Excel, Word, Powerpoint, Outlook, etc.
__________________
It's never too late to learn something new. Ricky |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
