Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel.training.course.london - excel vba

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.training.course.london - Excel VBA 2003

excel.training.course.london - Excel VBA 2003

ResolvedVersion Standard

Enida-eleni has attended:
Excel VBA Intro Intermediate course

Excel VBA 2003

What are the similarities between VB and Excel VBA?

Edited on Wed 16 Jan 2008, 13:53

RE: Excel VBA 2003 and VB

Hi

Visual Basic and Visual Basic for Applications both stem from the same language - Basic, so they have at least a fundamental similarity.

They both have a very similar level of Object Orientation.

The way you address objects and collections of objects, the way you respond to events, call methods and set properties is the same across both languages, although there are slight variations in the specific names of events or properties but in general they are almost the same.

There is a major difference between VB and VBA: a VB application is launched as an application in its own right, whereas the VBA program has to be launched by the host application eg Excel VBA.

Hope this answers your question

Carlos

RE: Excel VBA 2003 and VB


Thank you Carlos,

This is helpful. I think I will take it slowly, start with VBA and then move on to VB.

Thanks,
Eleni

RE: Excel VBA 2003 and VB

Good Luck

Carlos

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.