date picker in a table field

[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

( 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. !!! ) )

many thanks...

half newbie.... )

De Vo

 

[Word Heretic]

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: