Hi there,
I have another query, and after a day of trialling and searching for an answer, I hope someone here can help...
In my workbook, I have a userform. Userform is a timesheet, and allows for 2 different 'activities' to be entered (if needed) per day. Each combobox will have 4-5options (all the same)
I want to be able to select an option from the drop down box on any/all/some days, enter a number (hours) in the corresponding textbox, then calculate the total wage for each activity (there is also an 'hourly rate' textbox on userform) which will display on a worksheet summary page.
I.e Monday ActivityOne ComboBox = "Growing" Hours = 2
Tuesday Activitytwo combobox = Growing" Hours = 3
Then in my worksheet cell, I want to sum up all the 'Growing' hours (in this case 5), and multiply that by the wage rate, and display the result in the worksheet cell.
This is that portion of my code so far,
It doesn't 'error', all it currently does is display a '0' on my worksheet.....
I will also try to upload the file to save any confusion. The code I am having issues with in the 'Timesheet' userform, under the 'record timesheet' command
Thank you :-)
Bookmarks