What is the difference between VB and VBA?

Cosmos75 · Apr 16th, 2002, 10:54 AM

Like the topic says,
"What is the difference between VB and VBA?"

How does it affect what code I write for Excel?

[ This Message was edited by: Cosmos75 on 2002-04-16 09:56 ]

Al Chara · Apr 16th, 2002, 11:24 AM

You can read the following site:
http://www.excel-vba-access.com/vba-...tips-intro.htm

But it is best summarized as follows:

Quote:

*Should I learn VBA or VB?

Let's say that VB is for programmers and VBA is for users (or developers). Personally, I took hundreds of hours of training in VB but I do all my work in VBA (Excel and Access). You don't need to learn VB to be good at VBA. I adopted VBA because most of the functions I need to organize and analyze data are pre-programmed in Excel and Access. It costs a lot less to develop financial and management applications in Excel and Access than to re-invent the wheel and do everything in VB.

*What is the difference between VB, VBA for Excel, VBA for Access, VBA for Word, VBA for Project, etc?

To answer this question, I will ask you to imagine a meeting of five English speaking persons, a lawyer, an accountant, a physician, a chemist and a psychologist. They all speak English but when it is time to talk about their work, none of them totally understand the other. It is the same with each VBA, the objects, properties, methods and events vary from a language to the other.

Mudface · Apr 16th, 2002, 11:39 AM

Does anyone know what MS have planned for the 'next-gen' of VBA? I've heard quite a few programmers are disgruntled to say the least with the arrival of VB.Net (or VB.Not as some wags termed it).

Mark O'Brien · Apr 16th, 2002, 12:19 PM

It wouldn't surprise me if MS didn't know either yet. I doubt they'll do anything as drastic as the change from XLM to VBA though. VB and VBA have become very useful since their inception. Probably the only thing to halt VB or VBA would be if everyone switched Operating Systems.

Jack in the UK · Apr 16th, 2002, 12:50 PM

i have hurd no intentiobs to drop VBA ie Excels VB(a) . NET and XML is taking over VB does XLM in my company.. if that helps

Apr 16th, 2002, 12:19 PM	#4
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	It wouldn't surprise me if MS didn't know either yet. I doubt they'll do anything as drastic as the change from XLM to VBA though. VB and VBA have become very useful since their inception. Probably the only thing to halt VB or VBA would be if everyone switched Operating Systems. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 16th, 2002, 12:50 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	i have hurd no intentiobs to drop VBA ie Excels VB(a) . NET and XML is taking over VB does XLM in my company.. if that helps __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 10:54 AM	#1
Cosmos75 Board Regular Join Date: Feb 2002 Location: Tulsa, OK Posts: 354	Like the topic says, "What is the difference between VB and VBA?" How does it affect what code I write for Excel? [ This Message was edited by: Cosmos75 on 2002-04-16 09:56 ]

Apr 16th, 2002, 11:39 AM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Does anyone know what MS have planned for the 'next-gen' of VBA? I've heard quite a few programmers are disgruntled to say the least with the arrival of VB.Net (or VB.Not as some wags termed it).