Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Command Button to Sum specific cells in a range | Excel Programming | |||
Command Button Dependent on Cell/Range Value | Excel Programming | |||
Print from Command Button Range | Excel Discussion (Misc queries) | |||
Print range & Command Button | Excel Programming | |||
How to create command button to save the dates and time | Excel Discussion (Misc queries) |