Dialog Box and mouse selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Thank You,

That was just what I was looking for (and it was userform).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save user entered value in hidden lookup table. 4
Dialog Box Buttons 1
Mac Excel 2008 Problem Using Excel 4.0 XLM Dialog Box Option Buttons 9
Sorting issues... 2
Dialog Box returning Array Value instead of Actual List Value 3
interactive message with mouse selection 1
MS Excel VBA Worksheets group tables in one table. 1
Dialog for selecting range within subroutine 2

Back
Top