Calendar control not working

[lucas]

Hey guys,
I found this some time back and have been using it exclusivly. Even in Windows the native calendar control is not portable if they don't have the control in the system where you move it.

Works on sheet code but only pops up if you click a cell with a specific format.
might work on mac-don't know but worth a look.

This one is for excel

[MOS MASTER]

Hey guys,
I found this some time back and have been using it exclusivly. Even in Windows the native calendar control is not portable if they don't have the control in the system where you move it.

Works on sheet code but only pops up if you click a cell with a specific format.
might work on mac-don't know but worth a look.

This one is for excel

Hi,

What a beauty! Please do submit this one as well for a kb entry?

[lucas]

Hi,

What a beauty! Please do submit this one as well for a kb entry?

Thanks Joost I have had a lot of opportunities to use this and everyone likes it. The best part is its portability. I will submit it to the kb

[MOS MASTER]

Thanks Joost I have had a lot of opportunities to use this and everyone likes it. The best part is its portability. I will submit it to the kb

Exactly portabillity is the key word!

I've learned only this week from Shades & Blue Cactus in this topic that a mac doesn't support ActiveX (Btw I loved the other entry as well!...more work to try)

But I've never worked on a Mac so I didn't mis it...but it will come in handy one day for sure.

Later..

[Scottie P]

Exactly portabillity is the key word!
I've learned only this week from Shades & Blue Cactus in this topic that a mac doesn't support ActiveX (Btw I loved the other entry as well!...more work to try)
But I've never worked on a Mac so I didn't mis it...but it will come in handy one day for sure.

I am with you MM - never worked on a MAC and didn't realize ActiveX wasn't supported. I actually found out about the ActiveX issue 1 day before the thread started.

I was checking out your TimePicker application in the other thread. That lead me to go on to the Newsgroups to find something else that I had a question about. It was in one of the Newsgroup threads that I found out that MAC does not support the ActiveX feature. Who Knew?

Interesting and I suppose it creates some unique circumstances, but it also leaves open a great opportunity for someone creative with VBA...so maybe it isn't a bad thing

I think this thread and the one you were involved in both have provided me - and a few others - with some key information. Very cool.

S

[MOS MASTER]

I think this thread and the one you were involved in both have provided me - and a few others - with some key information. Very cool.
S

Well glad to here we've both learned new tricks.

[BlueCactus]

OK, I promise this is the last version for this thread. It is now the five-mode calendar. Feature-complete, suits my own purposes extremely well. Code is being washed and on the way to KB...

Features are now accessed through:

Call DatePick.FillVars([defaultDate][,dpMode][,forceCancel][,displayComments][,eventList])

defaultDate Optional as Date. The date to return if user clicks 'OK' without selecting a date. Defaults to current date.
dpMode Optional as Integer. Calendar mode: zero through four. Experiment away! Defaults to zero.
forceCancel Optional as Boolean. Do you want a 'Cancel' button. Defaults to False. 'Cancel' returns date as zero.
displayComments Optional as Boolean. Default False. Displays comments associated with event list items for dpmodes two through four.
eventList Optional as Variant containing Array. Dates as Variant Date in eventList(i,1). Event names in eventList(i,2). Comments in eventList(i,3) LBound(eventList, 1) = 1; LBound(eventList, 2) = 1

Edit: Code removed, see post #38.