Integrating Calendar with WorkSheet and UserForm

[NoobExcel12]

Hello,

I would like to Integrate Calendar with a Worksheet and a Userform.
My file is attached.

I Have a userform where I enter a new entry for my data sheet (Transportation_Tracking).
My wish is after I enter the data, the name depending on THE DAY and THE TIME will be insert automatically in my calendar to the accurate Cell. Like a Planning Table.

In my File, I have put in green the cell (in transportation_tracking sheet) the criteria that need to be in consideration.
In my file, I have put the Name Robert in the cell corresponding at my data sheet in the Calendar.

The goal is then to automatically Insert the Name ROBERT in the calendar depending on the Transportation_tracking Sheet when I finish to enter the entry in my userform.

Userform = Enter information in the data sheet (transportation_tracking) and put the name in the accurate cell (depending on Day and Hour)

Is it feasible ?

Thanks in advance guys

[NoobExcel12]

Hello again,

I still don't receive any help.

Just to know, someone can explain to me if I can do it, and where should I do/go to try to do it...

Thanks again

[mjr veverka]

Impatient, impatient ...

1. Modifications in the UserForm module:

Please Login or Register  to view this content.

2. Modifications in the Module1 module:

Please Login or Register  to view this content.

Ps.: Watch out for cell formatting.

[NoobExcel12]

Porucha Vevrku you 'r the best

I'll check it this week and keep you posted if its work

thanks mate