> Автор: Smiler™
> как программно вызвать диалог выбора диапазона ячеек в Excel как на рисунке?
>

Не пробовал перебрать парамеры у метода Item класса Dialogs
Help VBAA collection of all the Dialog objects in Microsoft Excel. Each Dialog object represents a built-in
dialog box. You cannot create a new built-in dialog box or add one to the collection. The only useful thing you can do
with a Dialog object is use it with the Show method to display the dialog corresponding dialog box.
....
Use Dialogs(index), where index is a built-in constant identifying the dialog box, to return a single Dialog object. The
following example runs the built-in File Open dialog box.

dlgAnswer = Application.Dialogs(xlDialogOpen).Show
The Microsoft Excel Visual Basic object library includes built-in constants for many of the built-in dialog boxes.
Each constant is formed from the prefix "xlDialog" followed by the name of the dialog box. For example, the Apply Names
dialog box constant is xlDialogApplyNames, and the Find File dialog box constant is xlDialogFindFile. These constants
are members of the XlBuiltinDialog enumerated type. For more information about the available constants, see Built-in
Dialog Box Argument Lists.


--
С уважением Горбонос Игорь Леонидович

Posted via ActualForum NNTP Server 1.4