| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button
If you have a list of tasks, and each item is marked as daily, weekly,
or monthly, you can use an AutoFilter to view one type of task. To apply an AutoFilter, select a cell in the list, and choose DataFilterAutoFilter. From the dropdown list in the Task Type column, choose Daily, and only the daily tasks will be visible. There are instructions in Excel's Help, and he http://www.contextures.com/xlautofilter01.html Joe wrote: Hi, I have some command buttons such that each button label as daily, weekly and monthly in which when i click on weekly task, it can display the list of the tasks to be run everyday and also the list of the tasks can be deleted or inserted. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Undo button and redo button quit | Excel Discussion (Misc queries) | |||
| Inserting a Graphic on a Button when the Button is Assigned to a M | Excel Discussion (Misc queries) | |||
| insert row above button (retrieve position of button) | Excel Discussion (Misc queries) | |||
| How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
| Delete a custom button by holding down the ALT key and dragging the button off the toolbar | Excel Programming | |||
Threaded Mode
