command button controlling a range of dates

[RedBeard]

Hi,

I would like to accomplish the following:

1. Have a command button that opens up a popup window.
2. Popup window is to have a calendar where you can select multiple
dates (or two calendars where you select start and end date).
3. Popup window will also have three radio buttons, with a value
assigned to each choice.
4. The selected date range will show up on the worksheet with each
date filled out with a number corresponding to the choice made with
the radio button, with each date having its own cell.

Am I trying to do too much with excel?

Thanks.

 

[joel]

This can be done in excel if you know what you are doing.

1) From VBA menu : Insert - Userform

2) Add to userform the frame (icon with abc). A frame is used so yo
can only select one radio button

3) Add 3 button inside the Fame.

4) Add calendar control to userform by right clicking the Toolbox an
select addional controls. Choose Calendar Control.

I don't know if you evver used a userform but you will need to writ
additional code inside the userform to handle everything you want to do
I just got you started