Attendance Userform Excel VBA code

Dear Members,

I request you to help me with Excel VBA code.

I have a Excel sheet with Horizontal date rows and vertical Members list.

Horizontal Date row starts from B1 to 365 days ( but here in sample Excel sheet uploaded I have given only 1 month for easy display on screen)

Vertical Members column starts from A2 to A...... ( but here in sample Excel sheet uploaded I have given only 20 members for easy display on screen)

The userform1 contains 2 comboBoxes and 1 Command button.

1st ComboBox for Members list
2nd ComboBox for Date List (dd/mm/yyyy) In our country we write date first, then month & then Year

When command button is clicked the word "P" is entered with reference to member's name (ComboBox1)and selected date (ComboBox2) into the specified cell. ("P" stands for Present)

(Note:- Whenever I use the code "Userform_Initialize" along with other codes for different work, the Command button gets Hanged or Freezes)
Can we avoid "Userform_Initialize" here.

Please It my request to you for the VBA code.

Attached Excel sheet with userform1

Regards,
Mukhtar56
(Country - India)

Dear Bakerman2,

How can I increase the date list in Combobox2 uptil 2025. In the list it is only for 1 year 2018.
The whole code is fine and working perfectly.
Lots of thanks and grateful to you for the help you gave so fast.

Regards,
Mukhtar56
(Country - India)

Dear Bakerman2,

Again Thanks to you for the help. I increased the value to 2922 to get date upto 31st Dec 2025.
Lots of thanks.
Regards,
Mukhtar56
(Country - India)