command button controlling a range of dates
 

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.

command button controlling a range of dates
 

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 you
can only select one radio button

3) Add 3 button inside the Fame.

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

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


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160919

Microsoft Office Help