LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Macro to create Sort buttons

Hello All
Bouyed with the recent help I got from this wonderful forum I have a
request which is a daunting one so not for the faint hearted....

In a previous employment someone had created a macro that sorted
columns. The macro would present a userform which initially would
request the user to state the number columns that Buttons would be
required for and on completion would create and place these at the top
of each column. On pressing any one of the buttons all the data would
be sorted by reference to that column. It also sorted out the data in
the other direction if the same button was pressed. Finally the
userform also presented an option to remove the buttons.
This sounds like a professional job but that is beacuse of my lack of
knowledge - any takers???

Many thanks for reading

ML
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create buttons? play4you New Users to Excel 2 November 22nd 06 07:36 PM
How do I create a Macro to sort data and insert blank rows & subto karinmpfa Excel Worksheet Functions 2 April 25th 06 09:57 PM
How do I create a scroll list of macro buttons? RobertM Excel Discussion (Misc queries) 1 October 31st 05 09:50 PM
Sort without moving buttons David P. Excel Discussion (Misc queries) 1 July 3rd 05 12:36 AM
Adding buttons in a sheet to sort data Jimbob Excel Discussion (Misc queries) 1 July 1st 05 06:27 PM


All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"