Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / December 2004

Tip: Looking for answers? Try searching our database.

date picker in a table field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
devo - 21 Dec 2004 20:51 GMT
Hi All

I am trying to create a template of a timesheer with box standard simple
calculations in (hours * rate per hour) .

One of the things is i need advise on is..

a) how to incorporate the date picker in to a template via vba

b) i wish to it so the picker is not visable until a button is pressed
(via macro) or if the user goes in to the cell where the date picker will
lie

c) how can i basically add 7 days on to the date pick on and then convert
that in to a correct date.

hope i not asking too much

( i do know this is a second post due to on the newbie section nobody wanted
to deal with the date picker in a field or attached to a macro. !!! :o) )

many thanks...

half newbie.... :o)

De Vo
Word Heretic - 22 Dec 2004 23:43 GMT
G'day devo,

Date picker never used one - normally I precalc the dates within a
range and just present something like a drop down of 1 Jan, 2 Jan, 3
Jan and so on.

Or you can do two dropdowns, one for month, one for day. Autoexit on
month sets day count correctly.

Use Now to get the current date and the Date* functions to do calcs.

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice

devo reckoned:

> Hi All
>
[quoted text clipped - 22 lines]
>
> De Vo
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.