LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 661
Default What is the best method to add a date picker to a spreadsheet?

I am trying to add a calendar control to a spreadsheet to function as a date
picker. I need to have a command button launch the calendar and then have
the date populate in a specific cell. I have added a user form and inserted
a Calendar Control 11 into the form. I do not know how to set the properties
of the calendar control to insert the date into a cell. The linkedcell
property is not available when the calendar control is inserted into the form.
Thanks, Paul.
 
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
pop up Date time picker Mike Excel Discussion (Misc queries) 3 November 17th 06 08:00 PM
Date Time Picker Mike Excel Discussion (Misc queries) 0 November 16th 06 04:36 AM
Date and Time Picker DAN J Excel Discussion (Misc queries) 2 September 21st 06 11:47 PM
Is there a way to get a Date Picker Box in Excel? Andrew Holzman Excel Discussion (Misc queries) 1 January 24th 06 09:46 PM
Date and Time Picker Control Andy T Excel Discussion (Misc queries) 0 January 6th 05 04:09 PM


All times are GMT +1. The time now is 02:06 PM.

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

About Us

"It's about Microsoft Excel"