I have a dialog box where user have to define an area (e.g. A10:C18) that
includes certain values. Is it possible to select the area with a mouse (so
that the selected area would appear in a text box)?

If you mean USERFORM when you say dialog box, then you can use the refedit
control. It should be with the other controls on your control toolbox - if
not you can add it using Tools=>Additional controls in the menu. It should
be listed separately as RefEdit.ctrl in the list of available controls (at
least it is for me in xl2003, Windows XP)

--
Regards,
Tom Ogilvy


"djExcel" wrote:

> I have a dialog box where user have to define an area (e.g. A10:C18) that
> includes certain values. Is it possible to select the area with a mouse (so
> that the selected area would appear in a text box)?

Thank You,

That was just what I was looking for (and it was userform).

"Tom Ogilvy" wrote:

> If you mean USERFORM when you say dialog box, then you can use the refedit
> control. It should be with the other controls on your control toolbox - if
> not you can add it using Tools=>Additional controls in the menu. It should
> be listed separately as RefEdit.ctrl in the list of available controls (at
> least it is for me in xl2003, Windows XP)
>
> --
> Regards,
> Tom Ogilvy
>
>
> "djExcel" wrote:
>
> > I have a dialog box where user have to define an area (e.g. A10:C18) that
> > includes certain values. Is it possible to select the area with a mouse (so
> > that the selected area would appear in a text box)?