date picker on a form

[devo]

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

many thanks...

half newbie.... )

De Vo

 

[Charles Kenyon]

Responding only to (c)...

This is more complex than you might imagine, but it can be done. See
http://addbalance.com/word/datefields2.htm for information on the different
kinds of ways to make a date calculation work. It includes links to pages
with fields and an explanation of different macros that can be used instead
of fields. Since you are already using a macro, that option will probably be
simplest.