Excel For Mac 2011 How Do I Insert A Checkbox

I have followed the following steps: Developer, Insert, More Controls, Microsoft Date and Time Picker Control 6.0 (SP4) and dragged the box wherever in the sheet. However I need this selection to be reapeated for an entire row. Ie I need the user to be able to select a date from a calendar for all the cells with the same column (Cloumn A). Feb 27, 2012 My VBA which works fine on Excel 2007/2010 does not work on Excel for Mac 2011. How I would convert this to work on Mac 2011? Code: Columns('AI:AI').Select Selection.TextToColumns Destination:=Range('AI1'), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _ [Code].