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

Is there a function that I can use to pull a calendar
into a userform. The user has to input a few dates and I
would like a calendar to come up when they get to that
input on the userform.

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

Jose -

In the VBA editor window, select View | Toolbox to display the Toolbox
window. Right-click on it and select the Additional Controls option. This
will pop up a window titled Additional Controls - scroll down in that window
until you find the Microsoft Date and Time Picker Control. Place an x in
the check box and the icon for the Date Time Picker Control should appear on
the Toolbox window. Click on it, then draw a rectangle on your userform and
you should be good to go!

HTH

James Cox

"Jose`" wrote in message
...
Is there a function that I can use to pull a calendar
into a userform. The user has to input a few dates and I
would like a calendar to come up when they get to that
input on the userform.

thanks



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 03:24 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"