#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Calendar

I am developing a Form in VBA. I need the user to enter a date. Is there
control available that can display a calendar for selecting a date?
Can I validate a Text Box to require a date, similare to Data Validation in
an on a worksheet cell?

thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,824
Default Calendar

You may want to use a freeware version of a calendar control.

From Ron de Bruin's site:
http://www.rondebruin.nl/calendar.htm

You can also Download the control on this page.
A Pop-up Calendar for Excel
http://www.fontstuff.com/vba/vbatut07.htm

Simon Shaw wrote:

I am developing a Form in VBA. I need the user to enter a date. Is there
control available that can display a calendar for selecting a date?
Can I validate a Text Box to require a date, similare to Data Validation in
an on a worksheet cell?

thanks


--

Dave Peterson

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 102
Default Calendar

Dave Nice Web-sites.... that's really useful stuff!

"Dave Peterson" wrote:

You may want to use a freeware version of a calendar control.

From Ron de Bruin's site:
http://www.rondebruin.nl/calendar.htm

You can also Download the control on this page.
A Pop-up Calendar for Excel
http://www.fontstuff.com/vba/vbatut07.htm

Simon Shaw wrote:

I am developing a Form in VBA. I need the user to enter a date. Is there
control available that can display a calendar for selecting a date?
Can I validate a Text Box to require a date, similare to Data Validation in
an on a worksheet cell?

thanks


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert date from Gregorian Calendar to Hijri Calendar H.Alkhodary Excel Discussion (Misc queries) 1 February 21st 09 10:11 AM
find free sharware to include calendar pop or use calendar in cell ednc Excel Discussion (Misc queries) 2 April 14th 08 05:05 PM
how do i export excel calendar info to outlook calendar? Maggie Excel Discussion (Misc queries) 1 December 31st 07 10:27 PM
excel calendar - list of names displayed on calendar Brian'88 Excel Worksheet Functions 3 November 17th 06 10:31 PM
import calendar items from excel into outlook calendar jsewaiseh Excel Discussion (Misc queries) 0 September 2nd 05 03:53 PM


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"