How do I create a Floating Date Picker.

**MattE23** · 03-02-2021, 05:24 PM

Good Evening all,

Does anyone know if it is possible to create a 'Floating' Date Picker?

I have created Floating Buttons etc.. but I am really struggling to find how to float a Date Picker.

I do not want to put it in the top Row and Freeze it, as I would rather have it floating down the worksheet as I scroll.

Any help is very much appreciated.

Thank you.

Matt

**Croweater** · 03-02-2021, 07:14 PM

This is what I have used in the past with my ancient version of Excel.

Insert your Calendar Control object and then use this code;

Please Login or Register  to view this content.

**MattE23** · 03-02-2021, 07:20 PM

Thank you for your response, I'll give it a go. much appreciated

**Crawfy** · 03-02-2021, 08:46 PM

I found this to be extremely easy to customize. https://trevoreyre.com/portfolio/excel-datepicker/

**torachan** · 03-03-2021, 05:28 AM

Give the attached a trial.
Double click cell for calendar to appear adjacent to cell.
Range can be restricted by changing the range in the Worksheet_Event.
torachan.