Sweet Excel Calendar Picker

[samrad]

I updated my calendar picker for Excel, check it out. Just add the xla it to your XLStartup folder and let the picking begin. Oh, it's free too.

http://www.isamrad.com/excelcal

 

[Harvey]

Can I execute it somehow in VBA, or in combination with text fields? I want it to pop up automatically.

 

[samrad]

I didn't think about making it availible through vba, I'll investigate. For now it's just on the right click menu and the in cell button.

 

[Harvey]

Okay, it looks nice, though I think I can use it only in my application, if I should be able to pop it up somehow. Is there no "main" function that runs the whole thing?

 

[samrad]

There is, DisplayCalendar(). But it will try to write the value back to the selected cell in the sheet. I'll see if i can modularize (is that a word?) it some more to work for ya.

 

[PA HS Teacher]

I installed your add in.

When I right click, and choose pick from calendar as instructed it seems to work fine. The calendar comes up.

When I choose a date, the following message:

Object variable or With block variable not set


I am running XL 2002.

(very catchy add in by the way)

 

[daniels012]

Now, if someone would come up with a clock!!!! There are soooooooo many Threads about "Time", it would be great to have a clock that does the same as the calendar.

Michael

 

[PA HS Teacher]

control + shift + : for the current time.

but a time picker would be a nice way to force users to enter time in a consistent manner.

 

[CraigM]

I love the idea. However I am having the same problem as PA HS Teacher above, with Excel 2003.

 

[Harvey]

restart excel to get it working