+ Reply to Thread
Results 1 to 3 of 3

copy temp sum in bottom right of excel to clipboard

Hybrid View

  1. #1
    Job
    Guest

    copy temp sum in bottom right of excel to clipboard

    Does anyone know how to take the value of the little window on the bottom
    right of excel (ie you highlight a group of numbers and it shows the sum or
    avg or whatever you choose.) and copy it to the clipboard?

    Cheers!



  2. #2
    Job
    Guest

    Re: copy temp sum in bottom right of excel to clipboard

    Anyone want to take a crack at this?

    "Job" <Job@nomail.com> wrote in message
    news:elGxRfvCFHA.2156@TK2MSFTNGP10.phx.gbl...
    > Does anyone know how to take the value of the little window on the bottom
    > right of excel (ie you highlight a group of numbers and it shows the sum
    > or avg or whatever you choose.) and copy it to the clipboard?
    >
    > Cheers!
    >




  3. #3
    Dave Peterson
    Guest

    Re: copy temp sum in bottom right of excel to clipboard

    I don't think I could get to that statusbar to retrieve the value, but maybe a
    macro.

    Option Explicit
    Sub testme()

    Dim MyDataObj As DataObject
    Dim myVal As Variant

    Set MyDataObj = New DataObject

    myVal = Application.Sum(Selection)
    MyDataObj.SetText myVal
    MyDataObj.PutInClipboard

    End Sub

    You'll want to read Chip Pearson's notes on working with the clipboard:
    http://www.cpearson.com/excel/clipboar.htm

    Especially:
    Because these procedures use the DataObject variable type, you must have a
    reference set in your VBA project to the Microsoft Forms 2.0 object library.

    If you're new to macros, you may want to read David McRitchie's intro at:
    http://www.mvps.org/dmcritchie/excel/getstarted.htm

    Job wrote:
    >
    > Does anyone know how to take the value of the little window on the bottom
    > right of excel (ie you highlight a group of numbers and it shows the sum or
    > avg or whatever you choose.) and copy it to the clipboard?
    >
    > Cheers!


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1