Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Interactive Buttons
I want to create buttons that will re-sort on different columns in the
spreadsheet. Does anyone have an example of this? Is it a marco I would use to create the button and the function behind it? Thank you. Mary |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Interactive Buttons
Hi Mary
Without using buttons, there is a absolutely superb method using invisible rectangles, written by Dave Peterson and available as both code and a down loadable file at Debra Dalgleish's site. http://www.contextures.com/xlSort02.html#Pivot and download Sortclick.zip Regards Roger Govier Mary wrote: I want to create buttons that will re-sort on different columns in the spreadsheet. Does anyone have an example of this? Is it a marco I would use to create the button and the function behind it? Thank you. Mary |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Interactive Buttons
I like this technique from Debra Dalgleish's site:
http://www.contextures.com/xlSort02.html Mary wrote: I want to create buttons that will re-sort on different columns in the spreadsheet. Does anyone have an example of this? Is it a marco I would use to create the button and the function behind it? Thank you. Mary -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Interactive Buttons
Roger and Dave,
You guys are my heroes! I will try the information you provided and let you know if it works! Thank you much! Mary "Mary" wrote: I want to create buttons that will re-sort on different columns in the spreadsheet. Does anyone have an example of this? Is it a marco I would use to create the button and the function behind it? Thank you. Mary |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Interactive Buttons
Roger and Dave,
This works for only one column sort, each of sorts will need three columns. Name - always Number - always and then by one of the following options Period of Performance Status POC Hmmmm - What do you think??? Not possible? I appreciate your assistance and expertise with Excel issues very much. Happy & Healthy Holidays! Mary "Roger Govier" wrote: Hi Mary Without using buttons, there is a absolutely superb method using invisible rectangles, written by Dave Peterson and available as both code and a down loadable file at Debra Dalgleish's site. http://www.contextures.com/xlSort02.html#Pivot and download Sortclick.zip Regards Roger Govier Mary wrote: I want to create buttons that will re-sort on different columns in the spreadsheet. Does anyone have an example of this? Is it a marco I would use to create the button and the function behind it? Thank you. Mary |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Interactive Buttons
I'd just click on the different headers.
Click on the name header, then the number header, then the period header (Or maybe reverse the order). If you really need separate macros, record the macros when you sort. Then drop a few buttons from the forms toolbar on the worksheet. Assign each button to a different macro. ======== I like the macro as-is. I think the way it works is more general--I can sort any which way I want. But you could modify this line: myTable.Sort key1:=.Cells(myTable.Row, myColToSort), _ order1:=mySortOrder, _ header:=xlYes to include the columns that should always be sorted. myTable.Sort _ key1:=.Cells(myTable.Row, 1), order1:=mySortOrder, _ key2:=.Cells(myTable.Row, 2), order2:=mySortOrder, _ key3:=.Cells(myTable.Row, myColToSort), order3:=mySortOrder, _ header:=xlYes (You'll have to change the column (I used 1 and 2) and you may even want to remove the rectangles from the fields that shouldn't be sorted. Just right click on that header cell and you'll "see" the invisible rectangle. Then hit the delete key.) (I still like to be able to sort as many ways as I like <vbg.) Mary wrote: Roger and Dave, This works for only one column sort, each of sorts will need three columns. Name - always Number - always and then by one of the following options Period of Performance Status POC Hmmmm - What do you think??? Not possible? I appreciate your assistance and expertise with Excel issues very much. Happy & Healthy Holidays! Mary "Roger Govier" wrote: Hi Mary Without using buttons, there is a absolutely superb method using invisible rectangles, written by Dave Peterson and available as both code and a down loadable file at Debra Dalgleish's site. http://www.contextures.com/xlSort02.html#Pivot and download Sortclick.zip Regards Roger Govier Mary wrote: I want to create buttons that will re-sort on different columns in the spreadsheet. Does anyone have an example of this? Is it a marco I would use to create the button and the function behind it? Thank you. Mary -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I make 2003 use the buttons icons of 2000? | Excel Discussion (Misc queries) | |||
No Buttons to Control Subtotal Levels!?!? | Excel Discussion (Misc queries) | |||
Using 'Option Buttons' | Excel Discussion (Misc queries) | |||
Vanishing Control Toolbox Command Buttons | Excel Discussion (Misc queries) | |||
iNTERACTIVE EXCEL FILE NOT INTERACTIVE ON THE WEB | Excel Discussion (Misc queries) |