View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Sort Ascending or Descending using Option Button

You may want to consider using a single checkbox with a "Sort Ascending" label.

Then you could just look at that one checkbox's value.

Gazza wrote:

I have a user-form with 3 option buuttons, depending on which option is
clicked the event runs and the data is sorted by the relevant column. How do
I add in an extra couple of options that will toggle between sorting the
data select option either ascending or descending.

thanks

Gaz


--

Dave Peterson