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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 03:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com