VBA version compatibility - Menu Editor

[Ibnbatouta]

I am trying to learn VBA. The method I am using is for VBA 6 and I am using VBA 6.3 (only the begining of my worries).

What is the Equivilant of the Menu Editor (crtl + e) in VBA 6.3. There is a whole chapter on learning it but I can't find it!

[willakawill]

I am trying to learn VBA. The method I am using is for VBA 6 and I am using VBA 6.3 (only the begining of my worries).

What is the Equivilant of the Menu Editor (crtl + e) in VBA 6.3. There is a whole chapter on learning it but I can't find it!

VBA is visual basic for application. Which application are you using? Is it Access, Word, Excel?

[Killer42]

Just to let you know, I've changed the thread title. If you're having a problem with differences between versions of a scripting language, there's nothing stupid about asking a question.

[Ibnbatouta]

VBA is visual basic for application. Which application are you using? Is it Access, Word, Excel?

I am using it to work with both Excel and Word but i can't seem to find that menu working with either application.

[Killer42]

I am using it to work with both Excel and Word but i can't seem to find that menu working with either application.

Sounds as though you must be coming from VB6, rather than VBA version 6. They're not the same thing.

VB creates standalone programs, with their own menus and so on. I'm not sure there is any equivalent in VBA, since it's a "scripting" language. That is, basically a way of automating operations within the application (Word, Excel etc.). If there is, it isn't on the Tools menu as in VB6.

On the plus side, if you like, you can use VB6 to work with Excel spreadsheets, Word documents and so on.

[Killer42]

The following topics in the VBA help (in Excel) may be of some interest...

• Adding and Managing Menu Bars and Menu Items
• Adding and Displaying Shortcut Menus
• Using Command Bars