Can I create a dropdown that will show a 2-month calendar?
I would like to have a drop down that shows 2 months for the user to select a
specific date. Is that possible? |
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? :confused: -- optionbase1 ------------------------------------------------------------------------ optionbase1's Profile: http://www.excelforum.com/member.php...o&userid=25212 View this thread: http://www.excelforum.com/showthread...hreadid=387993 |
All times are GMT +1. The time now is 03:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com