Pop Up Calendar

[lj2470]

I have been working on a spreadsheet and need a pop up calendar. I worked with the link suggested... http://www.fontstuff.com/vba/vbatut07.htm and it is not working. I checked my typing...and even finally copied and pasted...i cannot get to work. I get the calendar and can choose the date if I force the macro to run but I cannot get the option to show on my toolbar.

Also, I need to have a button to press to activate the calendar instead of the right click. Can you help me with this please?

State of Kentucky - AT&T Services Ordering Form Revised 07-17-14.xlsm

Any help would be great please!! Any other suggestions on improving this would be wonderful!

Thank you!!

[lj2470]

ok, I finally got the right click to show "Insert Date" and the shortcut keys are working.

What I need to know now if how I can put an icon to show there is a calendar or a button. Can someone help with this please?

[Arkadi]

lj2470,

Are you looking to insert a button in the spreadsheet?

[lj2470]

Yes. On the main spreadsheet I attached....for example, on Sheet 1, J11 , I would like to have some kind of icon or button for the user to know to press for the calendar to pop up.

[Arkadi]

is the Developer tab available at the top in excel? if not customize ribbon and add it. Then you can insert a button (i suggest form control), and then you can attach a macro to the button.

[lj2470]

Yes. It is available. That is what I used to get the calendar set up which is perfect except you have to right click on the cell. The people that use this may not know that so i need a little icon or button they will know to click on to get them to select the date, but the calendar itself is exactly right.

[Arkadi]

lj2470, as I said in the previous message, you can select insert then from the developer tab, and choose to insert a form control button. Then right click on button and assign the macro.

[lj2470]

Perfect! I got it. Thank you for your help!

[Arkadi]

Hey no probs!