I want a calendar pop up which a user can use to fill a cell in Excel.
Work so far and Problems:
1. (Excel 2007) Tried using microsoft common controls.
Problem is that MSCOMCT2.OCX file is not present with the installation and has to be installed separately (Installation process is lengthy and requires administrative access). Though the installation is one time, i cannot expect the users to register this component.
2. Solution from fontstuff.com
http://www.fontstuff.com/vba/vbatut07.htm)
Problem is that i have to manage in code separately for each excel versions.
3. Solution from stackoverflow.com: (http://stackoverflow.com/questions/...yyy-dates-in-textbox-in-vba/12013961#12013961)
Problem is that this creates extra sheets and also not very reliable.
4. Giving 3 combobox (dd-mm-yyyy) for each and letting user to select:
Problem is that i dont want user to do so much of interaction. means, first select date, then month and then year.
Is there any other way how i can use a calendar control for the user to do the date input?
Work so far and Problems:
1. (Excel 2007) Tried using microsoft common controls.
Problem is that MSCOMCT2.OCX file is not present with the installation and has to be installed separately (Installation process is lengthy and requires administrative access). Though the installation is one time, i cannot expect the users to register this component.
2. Solution from fontstuff.com
http://www.fontstuff.com/vba/vbatut07.htm)Problem is that i have to manage in code separately for each excel versions.
3. Solution from stackoverflow.com: (http://stackoverflow.com/questions/...yyy-dates-in-textbox-in-vba/12013961#12013961)
Problem is that this creates extra sheets and also not very reliable.
4. Giving 3 combobox (dd-mm-yyyy) for each and letting user to select:
Problem is that i dont want user to do so much of interaction. means, first select date, then month and then year.
Is there any other way how i can use a calendar control for the user to do the date input?