Comments on Yogesh Gupta's Excel Tips: Excel Macros : Excel Date Picker

Hello! I have try with your program and it works ...

2012-02-09T20:13:51.896+05:30

Hello!

I have try with your program and it works great, but I'm wondering if there is a way that a I can create a calendar on an UserForm and when I select a Date, this date will be written on a LisBox on an UserForm, do you kno how to do that??

thanks!

Hi, I need some quick advice. I used the SEP Date...

2012-01-31T01:07:32.928+05:30

Hi,

I need some quick advice. I used the SEP Date Control in Excel 2010 to create a date picker and would like to copy and paste the value of the date in a master spreadsheet. Is this possible?

Thanks,

T

I've had the same problem with the small float...

2011-12-28T11:06:38.666+05:30

I've had the same problem with the small floating button not popping up next to the cell and I believe I've solved the problem.

After you finish copying the code using the steps mentioned above, you notice that there's a little square "command button" that pops up where it's not supposed to be. It's actually two command buttons overlapping each other. They do nothing. One of them is supposed to be your floating button. It doesn't matter which one, you just have to name it or position it right.

1) Go into design mode (under the developer tab)
2) Click on your command buttons and seperate your command buttons from each other
3) Delete one and keep the other
4) Take that one command button and put it next to a date cell like it's supposed to be if the code had worked correctly. Pick any date cell, it doesn't matter
5) Click on its properties and change it's name to "FloatingButton" like it is written in the code. It might already be named like that though, no worries
6) Exit design mode and viola! You now have a floating calendar button that works like it should

You may notice that the button is plain with no calendar icon on it. Simple fix:
1) Enable design mode again
2) Click on your floating button and go to properties
3) Click on picture and browse for a calender picture (a decent calendar icon I found on google was this: http://www.insead.edu/events/leadershipsummitasia2010/images/calendar_icon.jpg)
4) Make sure the picture is centered by setting the picture position property to 12 (center)
5) Exit design mode and there you have it

Hope this works for everyone!

Has anyone figured out how to get the small button...

2011-12-07T01:20:59.952+05:30

Has anyone figured out how to get the small button to appear next to the cell when using the date picker? I can use it when right clicking and selecting date picker from the menu, but can't seem to get the small button to appear. I know I copied the code to a "T". Thanks.

sir, i m using drop down & vlookup function i ...

2011-11-07T16:56:15.304+05:30

sir, i m using drop down & vlookup function i creat a list of drop down. but when i use drop down it is working in sorting order. not in regular order.

Hello Yogesh, I am having difficulty adding this ...

2011-10-29T02:40:22.582+05:30

Hello Yogesh,

I am having difficulty adding this to my spreadsheet. If possible, could I email my workbook and you add your utility so that it works? I would appreciate any help!

- Michael

Yogesh, I'm a bit of a simpleton when it comes...

2011-10-27T19:00:10.888+05:30

Yogesh,
I'm a bit of a simpleton when it comes to these things but I tried to setup your date picker and am doing something wrong. It looks like from your description on how to use this all I have to do is place the downloaded file into the XLSTART folder where Excel saves recorded macros. I did that but now when I open one of my Excel files your file also gets opened and poking the Show Date Picker cell menu item yields a beep and locks until I poke ESC. I tried saving the file/macros as an XLA file but that didn't help (still two files and beeps). By the way - everything works fine in the date picker.xls sheet.

Can you help?

Hello Sir, How I can Maintain assets tag in excel ...

2011-10-13T09:42:35.451+05:30

Hello Sir,
How I can Maintain assets tag in excel workbook
please suggest.

Hi Yogesh, how can i activate the flowting calend...

2011-08-26T12:17:13.446+05:30

Hi Yogesh,

how can i activate the flowting calendar button on specific cells like you did in the "date picker" example excel sheet?

thanks!

Hi Yogesh, how to implement this date picker in a...

2011-08-12T21:50:05.109+05:30

Hi Yogesh,

how to implement this date picker in a protected sheet? Where do I have to insert Sheet1.Unprotect "password" line?

Its a great contrib anyway. Thanks!

when I have column were we have written a date lik...

2011-08-12T14:22:39.613+05:30

when I have column were we have written a date like...01-Aug-2011, I need to separate find out the month by using farmula, in other column in text like...Aug..

Hi Yogesh, This is the best date picker I have se...

2011-07-24T08:07:48.416+05:30

Hi Yogesh,

This is the best date picker I have seen. Wondering if you could help? I have very limited VBA skills and want to use your date picker function for certain cells throughout a spreadsheet. How do I change thye code such that the date picker pop-up in say cell G4 & L15 as an example? I will be emailing the file to others.

Many thanks, Nick.

it works for the most parts, but how come it dose ...

2011-07-20T05:27:03.039+05:30

it works for the most parts, but how come it dose not show floating button when mouse over the selected cell??

Hi there, For those who experience issues with the...

2011-06-28T18:13:08.920+05:30

Hi there,
For those who experience issues with the MonthView control, try the following:
Open command prompt and type:
regsvr32 mscomct2.ocx

if the file is actually missing, check http://support.microsoft.com/kb/297381

for 64bit systems, see also this thread
http://social.msdn.microsoft.com/Forums/en/sbappdev/thread/91cf3127-70fe-4726-8a27-31b8964430c5

Regards,
Martin

Hi Yogesh Could you please tell how this calender...

2011-06-26T19:45:49.677+05:30

Hi Yogesh

Could you please tell how this calender utility activates when one select any particular cell??

I mean if I select any cell in range it should pop up calender...

Thanks

Can you please describe step by step how to utiliz...

2011-06-10T23:30:43.743+05:30

Can you please describe step by step how to utilize the code for the datepicker. I'm trying to but can't figure it out. I'm not too computer savvy. Thanks! Also I have MS Office Excel 2010. Is this an issue?

I too am having problems with MonthView1 being und...

2011-06-08T19:15:32.228+05:30

I too am having problems with MonthView1 being undefined with Office 2007. Can you please help?

Hi Yogesh, I'm trying to convert your vba code...

2011-05-17T12:28:06.969+05:30

Hi Yogesh, I'm trying to convert your vba code in order to make it works on Office 64bit.
But I got stuck at UserForm "Sub UserForm_Activate()"
It said do not have method "MonthView1"
I know vba7 has no more MonthView control.
Maybe you have some clue ?

Help. When I used the popup calendar. The floati...

2011-04-14T01:54:58.568+05:30

Help. When I used the popup calendar. The floating button is just white with no icon inside. newby here.

Yogesh , how are u. i am having may excel files in...

2011-02-18T19:46:06.666+05:30

Yogesh ,
how are u. i am having may excel files in a folder and each excle contains 3 woorksheets.

can you please help me in a macro to print all the excle files ( that includes all 3 woork sheets )each in a folder and also another to make pdf and save in a folder

I would like to limit the selectable dates to 01-0...

2010-12-05T03:10:13.177+05:30

I would like to limit the selectable dates to 01-01-2011 till 31-12-2011. How do I do that?
Thanx

Great article! In case anyone is coding-challenged...

2010-12-03T00:16:00.541+05:30

Great article!
In case anyone is coding-challenged and wants app solution, the following Excel date picker is now Free:
http://www.wincalendar.com/excel-pop-up-calendar.html

Dear Yogeshji, Excel Date Picker is not working i...

2010-11-20T11:10:37.143+05:30

Dear Yogeshji,

Excel Date Picker is not working in office 2007.

Pls Confirm.

Upendra Singh

Hi Yogesh, I am using Excel 2010 (64 bit) on Wind...

2010-10-07T02:01:30.991+05:30

Hi Yogesh,

I am using Excel 2010 (64 bit) on Windows 7 (64 bit), and I am unable to get the date picker to work. Have you tried getting a date picker to work on 64 bit Excel 2010?

Cheers,

Paul

Thanks for this calendar picker code Yogesh. I add...

2010-09-17T03:43:27.394+05:30

Thanks for this calendar picker code Yogesh. I added it to a workbook to be shared with others. Only issue is I don't see the button although it works fine by right clicking and selecting "Show date Picker".