Re: are default values possible for "Application.Dialogs(xlDialogSortSpecial).show "?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hi Jim,

Thank you very much, yes, I am preselecting an area based on a dynamic
named range which is also used to set the print area.
I think my problem with the ".show" was when I tried listing the
arguments was that I attempted to fill in the "sort_by, method" & not
just use a ", , " as spacers. I won't have a chance to experiment until
tomorrow but it looks like it will help tremendously :-)
Once I understand how to make the row headers appear in the form
(rather than the absolute addresses for the sort ranges). If I can't
figure it out I'll be in touch...

Once again thanks for your guidance,
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


Jim Cone Wrote:
> Hello Rob,
>
> The Excel sort utility does not allow the user to change the selection
> once the form is shown. It sorts the selection chosen before the
> form is shown or uses the current region to sort... one or the other.
> You as the code writer, of course, can select any range you want
> before showing the form.
> As far as the other options go...shown below is a crude example.
> Experiment with it...substitute various values and see what you get...
> '----------------------
> 'From the help file
> 'xlDialogSortSpecial sort_by, method, key1, order1, key2, order2, key3,
> order3, header, order, case
>
> Application.Dialogs(xlDialogSortSpecial).Show _
> , , Range("B12"), xlDescending, Range("D12"), xlDescending,
> Range("E12"), xlAscending, xlYes, xlTopToBottom, False
> '----------------------
> Regards,
> Jim Cone
> San Francisco, USA
> http://www.realezsites.com/bus/primitivesoftware
>


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30068
View this thread: http://www.excelforum.com/showthread.php?threadid=501426

.

Relevant Pages

  • Re: Sorting columns
    ... I'm sorry Jim, ... When i go to the Sort Dialog Box, click "Sort left to right" (after ... Joyce @ fMX ... "Jim Cone" wrote: ...
    (microsoft.public.excel.misc)
  • Re: Two more farms?
    ... A sort of sanity ... I am curious as to how Pat would react. ... Jim obviously lobbies ... Jill is an egocentric cut and paste merchant ...
    (uk.business.agriculture)
  • Re: OT: Climate Change
    ... It's a sort of mild McCarthyism. ... Jim is as far out of touch with reality as ever, ... force him to ride a bike would be a "true fascist" escapes me. ... stopped when he left primary school, and it can't have been much of a ...
    (sci.electronics.design)
  • Re: Macro to hide rows with a certain cell empty then set print area and print
    ... Jim - Thank you for such a quick response. ... Which part of the macro is hiding the rows where column Q is empty? ... If the proper rows and columns are hidden, why set a print area? ... hide the rows of records with no information in the cell (cell would be ...
    (microsoft.public.excel.programming)
  • Re: OT: FOAK: Paging the computer security wonks
    ... Using the patented Mavis Beacon "Hunt&Peck" Technique, Jim typed ... box running VSFTPD, what sort of world of hurt have I exposed myself to? ...
    (uk.rec.motorcycles)