Customize Find Dialog Box

Thread view:

Thread rating:

Elaine - 09 Jun 2006 06:55 GMT

The Find dialog box is defaulted to find by rows, how do I change the default
from rows to columns.

Signature

Thank you... Elaine

Ardus Petus - 09 Jun 2006 07:31 GMT

d=application.dialogs(xldialogformulafind).Show (,,,xlbyrows)

HTH
--
AP

> The Find dialog box is defaulted to find by rows, how do I change the
> default
> from rows to columns.

Elaine - 12 Jun 2006 14:06 GMT

Ardus,

Please expand on answer. Where do I place these instructions.

Signature

Thank you... Elaine

> d=application.dialogs(xldialogformulafind).Show (,,,xlbyrows)
>
[quoted text clipped - 5 lines]
> > default
> > from rows to columns.