Calendar Control and userforms - newbie help

[sentinal]

hi

i have set up a calender control with 2 text boxes. upon the first selection of a date the first box is populated (textFrom) and the second selction of a date the second box is populated (textTo)

i also have 2 option buttons upon selection populates the dates with fixed values,

ie 1 week from current date

or 3 weeks from current date

any ideas how to do this ? im struggling with the latter part . I think it is because the calendar is setup as a "click" event and the box (txtFrom txtTo) are only populated once the calendar itself is "clicked"

I can get it to work if i select either of the week options ie 1 or 3, if i click the calendar after. Is there anyway to get around this ?

many thanks for the forum, helped me many times this is the first time ive had to post a problem

many thanks