Dialog Box and mouse selection
 

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)?

Dialog Box and mouse selection
 

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)?

Dialog Box and mouse selection
 

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)?