pmeenak
01-03-2012, 04:36 AM
I am very new to VBA Coding in Excel. I try to create a Timesheet form in Excel which is available in the link provided at the end. I found the coding is very extensive and I got 'Run Time Error 1004' when the RESET button is clicked with values in 'Week Ending' cell and AGroup1 combo box. When I tried to debug, the error is happening at the following line in ' Private Sub Reset_Click()'
'Range("B7,B8,D12:K61").Value = "" '
Could anyone help me to resolve the issue? Like that, is there any simple way to find the changes in form objects instead of writing code for each and every form object in the form?
File Factory Link: "filefactory.com/file/c1cf992/n/Timesheet_yyyy-mm-dd_v1.xlsm"
'Range("B7,B8,D12:K61").Value = "" '
Could anyone help me to resolve the issue? Like that, is there any simple way to find the changes in form objects instead of writing code for each and every form object in the form?
File Factory Link: "filefactory.com/file/c1cf992/n/Timesheet_yyyy-mm-dd_v1.xlsm"