Excel 2007 Forms Design

[Frikkels]

Is it still possible in excel 2007 to create/add radio boxes, buttons etc to
a workbook/spreadsheet. This functionality was available in 2003. It used to
be on a Forms Toolbar, but i cant seem to find this in 2007

 

[Ed Ferrero]

Hi Frikkels,

You need to show the developer ribbon.

Click on the office logo (round thing with squiggles in it at the top left)
Then click Excel Options (bottom of the dialog)
Enable the third check box down.

Now go to the Developer tag/ribbon.
Insert has Form and ActiveX controls

Ed Ferrero
www.edferrero.com

 

[Andy Pope]

Hi,

Yes it is. However you need to enable the Developer tab within the ribbon.
Office button > Excel Options > Popular > Show Developer tab in Ribbon.

Then within the new Developer Tab > Controls > Insert.

Cheers
Andy