Results 1 to 6 of 6
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Reference Button (Excel 2K)

    In the attached graphic, in the reference section, you'll see a familiar feature of Excel. Namely, the button that the user can click on and then click and drag to select an area of the spreadsheet.
    My question: How the heck to get this into my own form... is it a dialog I reference? - I don't find it on the user form toolbar.

    Any suggestions are welcome
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Reference Button (Excel 2K)

    Oops found it <img src=/S/blush.gif border=0 alt=blush width=15 height=15> - it IS on the user form toolbar. My inability to draw a tidy square prevented me from seeing it. However, it doesn't display the same way as when it appears in a dialog box. I want to make this look the same as what my users are familiar with. Any suggestions?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Reference Button (Excel 2K)

    Which one did you find? There is the refedit control, which looks like that when pressed.

    If you are not making a form, you can use application.inputbox (type:=8) [This is different than a inputbox without the application!] to select a range from a dialog box.

    Steve

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Reference Button (Excel 2K)

    Which one did you find? There is the refedit control, which looks like that when pressed.

    ----
    But not before it is pressed....
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Reference Button (Excel 2K)

    The RefEdit control is the best you're going to get. Excel doesn't provide a control that looks exactly like the one used in the built-in dialogs.

    I did a limited Google search, and I failed to turn up any third-party replacement for the RefEdit control.

  6. #6
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Reference Button (Excel 2K)

    Thanks for checking that out - always good to know I haven't lost it!
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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