How to retain useform data and how to set the ranges if the ranges needs to change based on the cell ( trigger for userform ) double clicked

[Chucky3006]

Good day to all

I require a complicated code regarding userforms.

1. I managed to create the user form.
2. I managed to link the user form data to only specific cells.

The challenge i am faced with is the following:

On sheet1 i have a spread sheet indicating all the employees and each day for the month.

I need to indicate the overtime worked for each employee on each day or indicate if the employee was present.

on sheet9 I have a form that must be printed for application of the overtime.

So the idea is to double click the applicable date for that employee's overtime (ex. F2 ) the userform form pops up i enter multiple data into multiple datepicker boxes and text boxes. I then select a commandbutton that saves the data in cells ( sheet1) and enter the data on the form (sheet2) and then prints the form on sheet2 with the default printer. when i doubel click on F2 the data previously entered should be brought back into the userform but when i exit the userform it should not print only when i select command to print should it print. Al of this should also aply when i doubble click ( E7 )

Rows 3,4,5 and 6 will be hidden.

	A	E	F	G	H	I
1		10-03-2018	11-03-2018	13-03-2018	14-03-2018	15-03-2018
2	Chucky	PRESENT	4 HOURS	4 HOURS	DAY OFF	PRESNET
3	textBox1 data		cover John annual leave
4	TextBox2 date		applied by Hein
5	DTPIcker1 data		07h00
6	DTPicker2 data		11h00
7	Pieter	4 hours	A/L	A/L	PRESENT	PRESNET
8		cover Peet annual leave

<tbody>
</tbody>

I will really appreciate assistance on this one.