PC Review


Reply
Thread Tools Rate Thread

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

 
 
gimme_this_gimme_that@yahoo.com
Guest
Posts: n/a
 
      16th Feb 2010
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.


 
Reply With Quote
 
 
 
 
gimme_this_gimme_that@yahoo.com
Guest
Posts: n/a
 
      16th Feb 2010
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.

 
Reply With Quote
 
Mike Middleton
Guest
Posts: n/a
 
      17th Feb 2010
gimme_this_gimme_that -

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

- Mike
http://www.MikeMiddleton.com



<(E-Mail Removed)> wrote in message
news:98bfe369-2702-4a46-9a87-(E-Mail Removed)...
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.

 
Reply With Quote
 
Mike Middleton
Guest
Posts: n/a
 
      17th Feb 2010
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



<(E-Mail Removed)> wrote in message
news:6e56c569-ceeb-4fda-81dd-(E-Mail Removed)...
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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 ribbon Controls & "My.Settings" equivalent in VBA rogge Microsoft Excel Programming 0 8th Jan 2009 11:33 PM
Custom Ribbon example in Walkenbach's "Excel 2007 Power Programming with VBA" Greg Lovern Microsoft Excel Programming 1 16th Sep 2007 03:42 PM
"Microsoft Access can't find the Visual Basic for Applications DLL vba332" sonar007@yahoo.com Microsoft Access 0 9th Feb 2006 09:32 AM
Can't remove "Visual Basic" toolbar & cannot add toolbars thru cus =?Utf-8?B?R2F2?= Microsoft Excel Discussion 0 30th Nov 2005 12:55 AM
I Visual Basic Error "File Not Found" when Excel opens =?Utf-8?B?QnJlbnQgRQ==?= Microsoft Excel Misc 1 2nd Mar 2005 03:20 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:50 PM.