[VBA]Private Sub CommandButton1_Click()
'Workbooks("TGSItemRecordCreatorMaster.xls").Worksheets("Record Creator").Activate
Worksheets("Record Creator").Select
With Worksheets("Record Creator")
.Range("A2").Select
End With
End Sub[/VBA]
A userform is created in the vbe. Go to insert and click on userform. All of the controls you can add from the toolbox are activeX controls....not just the buttons. You can also add activeX controls to the worksheet by making sure the Visual basic toolbar is visable and select your controls from there.

You can add other controls to the sheet which are not ActiveX controls...they are added from the forms toolbar.

right click on any toolbar while looking at a spreadsheet and make sure that Forms and/or Visual basic is checked.