Can I create a dropdown that will show a 2-month calendar?

[Vecchia]

I would like to have a drop down that shows 2 months for the user to select a
specific date. Is that possible?

[optionbase1]

Can help you with one month drop-down .... not sure this is your answer ...

Create a blank userform and place the DTPicker control as the only control (DTpicker may be on your controls TOOLBOX menu; if not right-click on the TOOLBOX select Additional Controls and locate DTpicker)

you need to initialise the userform :

Private sub Userform_Activate()
Me.DTpicker.value = Date
end sub

and also set an event for the DTpicker control ( I have this set to record the selected date then hide the userform):

Private Sub DTpicker1_Closup()
Activecell = DTpicker.value
UserForm1.hide
End sub


I have then a simple calling macro (triggered by a keyboard shortcut) that has a single line :

Userform1.show

- hit the shortcut to show the dialogbox, select the date and it is entered in the activecell;

you could use the Calander control if you prefer the look but this is still one month only ...

Don't know how to make this display 2 months together; any ideas anyone?