ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calendar (https://www.excelbanter.com/excel-programming/318679-calendar.html)

Jose`

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

James Cox[_2_]

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





All times are GMT +1. The time now is 02:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com