Date Picker in a pre-determined row of cells?

[Thlian]

I can`t VBA so this has to be plug and play, I can read some of it but mostly it makes no sense.

But I want a whole row of cells that when pressed the calendar pops up right next to it, pick the date and the calender closes automatically.

I have tried this one
https://www.youtube.com/watch?v=kYNaiXmbcoA&t=300s

I`ve followed the tutorial step by step 4 times but it still it leaves a date picker up in the left upper corner and it whenever and wherever I press I get a debug error code. Isn`t that funny.....Any help?
Other tutorials etc that would work?

[Mumps1]

Which row?

[Thlian]

This for example A4:A34

[Mumps1]

Try the attached file. Just click anywhere in your range A4:A34.

[Thlian]

Try the attached file. Just click anywhere in your range A4:A34.

And this I can't Just copy into my excisting work book?

[Mumps1]

Yes you can. Open both files. Hold down the ALT key and press the F11 key to open the VBA Editor. In the left hand pane, drag and drop the user form from the file I sent to your file. Close the VBA Editor and right click on the tab in my file and click 'View Code'. Copy the macro and then right click the tab in your file, click 'View Code' and paste the macro there. Close the code window to return to your sheet.

[Thlian]

Yes you can. Open both files. Hold down the ALT key and press the F11 key to open the VBA Editor. In the left hand pane, drag and drop the user form from the file I sent to your file. Close the VBA Editor and right click on the tab in my file and click 'View Code'. Copy the macro and then right click the tab in your file, click 'View Code' and paste the macro there. Close the code window to return to your sheet.

Can I edit the way the date appear?

[Thlian]

Also the wrong way, we use ddmmyy

If you can pleas add scrennshots of where format can be changed, thx

[Mumps1]

All you have to do is format the range A4:A34 to the desired format. Select the range, right click on any cell in the range and click 'Format Cells'. Choose 'Custom' and enter the desired date format.