Hello all,

Having managed to create a reporting tool, first attempt at excel VBA, my
manager now wants an update built in. I thought the easiest way would be to
call the Standard Form from the Data tab. Although by simply highlighting the
cells, and selecting from the drop down lis, my code does not appear to work.

Private Sub CommandButton1_Click()
Dim ws As Worksheet
Set ws = Worksheets("GSOPs")
Range("A3:H32").Select
With ActiveSheet
..ShowDataForm
End With

Any suggestions would be gratefully recieved. 2 days to finish this off and
multiple sheets to build in to the options.

Thanks,

End Sub


--
Brian McCaffery