LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 158
Default pop up calendar using MS DateTime Picker

I looked over Ron Debruin's excellent site to create a pop-up calendar, but I
think having to get all my users to download the add-in would be problematic.
Then I noticed in a book* a description of Microsoft's "Date and Time Picker
Control", which seems to be available to everyone using 2003. But when I
tried to implement it, it seems like the pop-up - which is always visible
(not a problem) - can only be linked to one cell (a problem). Instead of
dropping the date into the "active" cell, it updates the one you have linked
to. And if you try to link to a range, e.g., D3:K8, it ignores everything
except the initial single cell referenced. Am I just doing something
wrong/does anyone know whether DateTime Picker can be used across multiple
cells?

TIA.
 
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
Formatting datetime problems importing data from mysql db PEA Excel Discussion (Misc queries) 2 February 23rd 06 11:04 PM
MS Query DateTime String Dean Excel Worksheet Functions 1 January 23rd 06 12:07 PM
Removing characters from datetime field Sujesh Excel Discussion (Misc queries) 3 July 14th 05 03:22 PM
Creating a calendar in a cell for a date-picker MarkieE Excel Worksheet Functions 1 January 26th 05 12:08 AM
autodate and datetime stamp DC Gringo Excel Worksheet Functions 1 December 3rd 04 06:25 PM


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

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"