Excel VBA

The UK's most regular instructor-led training courses.
Training information: excel vba courses · Excel advanced · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel VBA

Michael has attended:
Excel Advanced course

by - delegate Michael [1 post] (2008 Feb 13 Wed, 12:57) Reply

Where I can find the VBA toolbar for excel in the excel 2007?
Thank you!

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel VBA

by - trainer Stephen gold contributer [281 posts] (2008 Feb 13 Wed, 13:25) Reply

Hi Michael

Thank you for your question

There are no toolbars as such in Excel 2007

To be able to access the developer tool, you need to go to Tools-Options.

In the resulting dialog box you will find an option to show/activate developer view.

Tick this, and the developer tab will appear at the top of your screen

Hope this is useful

Regards

Stephen

RE: Excel VBA 2007 - developer tab

by - trainer Katie gold contributer [202 posts] (2008 Feb 13 Wed, 13:30) Reply

Hi Michael,

Thanks for your question.

In Excel 2007, the VBA toolbar is hidden in Developer Tab

1) Click on Office Button (top left corner)
2) Select Excel Options
3) Click on Popular Category
3) Click on checkbox "Show Developer Tab in the Ribbon"
4) press OK

Hope this helps.

Regards,

Katie Woo
Microsoft Certified Trainer