Can't find "Visual Basic" Toolbar on Excel 2007 Ribbon

  • Thread starter gimme_this_gimme_that
  • Start date
G

gimme_this_gimme_that

I want to place buttons and dropdowns on a 2007 Excel Workbook.

I don't see a Visual Basic category anywhere on the ribbon and don't
see a place in preferences where you add it.

But I haven't developed in VB in 2007 before - so I figure it's there
some where.

Where do you get access to VB controls now - or is Microsoft phasing
that VB controls and forcing developers to use forms only?

Thanks.
 
G

gimme_this_gimme_that

In addition to the Visual Basic Toolbar - I need the Forms Toolbar as
well.

The VB Toolbar has the start/stop/debug macro stuff.

The Forms Toolbar has the buttons and dropdowns.

For now I'm creating in 2003 and swapping out to 2007.
 
M

Mike Middleton

gimme_this_gimme_that -

Office Button (top left orb icon ) > Excel Options > Popular > Show
Developer tab in the Ribbon

- Mike
http://www.MikeMiddleton.com



I want to place buttons and dropdowns on a 2007 Excel Workbook.

I don't see a Visual Basic category anywhere on the ribbon and don't
see a place in preferences where you add it.

But I haven't developed in VB in 2007 before - so I figure it's there
some where.

Where do you get access to VB controls now - or is Microsoft phasing
that VB controls and forcing developers to use forms only?

Thanks.
 
M

Mike Middleton

First: Office Button (top left orb icon ) > Excel Options > Popular > Show
Developer tab in the Ribbon

Second: Developer > (Controls) Insert > Form Controls

- Mike
http://www.MikeMiddleton.com



In addition to the Visual Basic Toolbar - I need the Forms Toolbar as
well.

The VB Toolbar has the start/stop/debug macro stuff.

The Forms Toolbar has the buttons and dropdowns.

For now I'm creating in 2003 and swapping out to 2007.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top