funkmonsteruk
IS-IT--Management
I have a user form which i need to perform several task.
It is basically used to control a visual diary with each cell in the diary basically representing an hour of somebodies working day. I would like the user to be able to select a worker from a listbox, select a task from another listbox and enter start and end times (and date) for how long the task will take.
When they have clicked on a command button i would like the relevant page of the spreedsheet (a page for each worker) to be updated with the relevant hours being coloured to represent the task and text wich the user inputs to a text box being added to the first of the selected cells.
Any help would be very gratefully excepted.......
It is basically used to control a visual diary with each cell in the diary basically representing an hour of somebodies working day. I would like the user to be able to select a worker from a listbox, select a task from another listbox and enter start and end times (and date) for how long the task will take.
When they have clicked on a command button i would like the relevant page of the spreedsheet (a page for each worker) to be updated with the relevant hours being coloured to represent the task and text wich the user inputs to a text box being added to the first of the selected cells.
Any help would be very gratefully excepted.......
