Calendar Control and userforms - newbie help

sentinal

New Member
Joined
Feb 18, 2005
Messages
34
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
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,122,232
Messages
5,594,956
Members
413,954
Latest member
mrsandy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top