Results 1 to 2 of 2

Thread: Select Range With Mouse *RESOLVED*

  1. #1

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383

    Question Select Range With Mouse *RESOLVED*

    When you use the built-in functions of Excel you often click a little
    button which allows you to select a range with your mouse.

    I figure that it must be a control or something that I can put on a form?

    Does anyone know how I can emulate this?
    I am trying to create a Wizard to do a complicated function.

  2. #2

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383
    Include a RefEdit control in your UserForm (reference it first) to select a
    Range imitating the behavior of the reference edit boxes that are built
    into Excel. See the Microsoft Knowledge Base Article nº 213776 or 158402:
    http://support.microsoft.com/default...b;en-us;213776
    http://support.microsoft.com/default...b;en-us;158402

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width