Using Form elements in Excel 2007

Posted on 2009-12-27
Medium Priority
Last Modified: 2012-05-08
I have long been accustomed to using Excel 2003, and I've been laboring to get used to 2007 at work.  I really don't like the ribbon, and I'm sorry they did such a major redesign of the reliable and capable drop-down menu.  
I am trying to figure out how to place form elements in an Excel worksheet, and none of the menus seem to provide this most basic function.  As an experiment, I created a simple button in 2003 and opened the file in 2007; and my button both opened and performed the desired function when I pushed it.  From that experiment, I surmise that the capability of creating buttons, text boxes, check boxes, radio buttons, etc. in 2007 must exist, I just can't find it.
Best, ~Peter Ferber
Question by:PeterFrb
  • 2

Accepted Solution

syeager305 earned 2000 total points
ID: 26129536
You need to turn on the developer ribbon, (I know it's lame)... click on the file ribbon (or hit the flag), and select Excel Options
then on the right hand side select popular, then the third checkbox down you will see "show the developer toolbar in ribbon" or something like that.

Author Closing Comment

ID: 31670299
Lame is the word!  (Excel, not you.)
Best, ~Peter

Author Comment

ID: 26129549
Yes, that's right, lame though it be.

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question