Calendar help (97/2k)

Topic

New Reply

I’ve searched previous posts but I cannot quite find what I’m looking for. It’s bound to be simple but…
How is the calendar control referenced in VBA. For example, how would I get a specified cell to show the selected date?

Ta!

Rob

Reply | Quote

Replies

Rob

OK the easy way is to use the value of the Calendar control.

Use something like this:

Private Sub Calendar1_Click()
MsgBox Calendar1.Value
End Sub

Let me know if you need any further help.

Wassim

Reply | Quote

Thanks Wassim

I’ll give it a go.

Rob

Reply | Quote

Microsoft’s Using a Calendar Control in Excel has complete instructions. HTH –Sam

Reply | Quote

Thanks Sam. That’s really useful.

Rob

Reply | Quote

> Microsoft’s Using a Calendar Control in Excel has complete instructions. HTH –Sam

Thanks for the reference.

This apears to have been moved/lost, perhaps due to withdrawal of support.
You don’t still happen to have a copy, do you?

Reply | Quote

Still there http://www.microsoft.com/exceldev/articles/CalExcel.htm%5B/url%5D –Sam

Reply | Quote

The page is still there, but clicking on the link takes me to http://www.microsoft.com/exceldev/articles/Exe/CalExl.EXE which tells me “We

Reply | Quote

I see what you mean. Unfortunately, I did not download the sample code. The best I can find now is the download for the control, second link on http://www.microsoft.com/officedev/index/calendar.htm%5B/url%5D. Perhaps all of the code is in the text of the article. Sorry!

Reply | Quote

I see what you mean. Unfortunately, I did not download the sample code. The best I can find now is the download for the control, second link on http://www.microsoft.com/officedev/index/calendar.htm%5B/url%5D. Perhaps all of the code is in the text of the article. Sorry!

Reply | Quote

This doesn’t get you the Miscrosoft code, but you could also try the code and calendar addin from here

Steve

Reply | Quote

Thanks Steve, I think this was the thing that got me started. This is the MSoft OCX for the form. I was looking for an alternate to the OCX; apparently that comes ONLY with Access, but MSoft had released a free-standing, and free, version.

Reply | Quote

Thanks Steve, I think this was the thing that got me started. This is the MSoft OCX for the form. I was looking for an alternate to the OCX; apparently that comes ONLY with Access, but MSoft had released a free-standing, and free, version.

Reply | Quote

This doesn’t get you the Miscrosoft code, but you could also try the code and calendar addin from here

Steve

Reply | Quote

The page is still there, but clicking on the link takes me to http://www.microsoft.com/exceldev/articles/Exe/CalExl.EXE which tells me “We

Reply | Quote

Still there http://www.microsoft.com/exceldev/articles/CalExcel.htm%5B/url%5D –Sam

Reply | Quote

> Microsoft’s Using a Calendar Control in Excel has complete instructions. HTH –Sam

Thanks for the reference.

This apears to have been moved/lost, perhaps due to withdrawal of support.
You don’t still happen to have a copy, do you?

Reply | Quote