Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Value of active cell to appear in different cell

  1. #1
    New Member
    Join Date
    Sep 2009
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Value of active cell to appear in different cell

    I would like the contents of a selected active cell to be displayed in a certain other cell, say R4. When another cell is selected and active, that cell's contents should be displayed.

    I have an array of 9 columns and 20 rows with equity symbols and conditionally formatted to show the severity of price movement in either direction.

    Instead of typing in the value of whatever cell a trader is looking at I would like for them to just be able to click on the cell and have that symbol copied into R4 so some detailed information can be displayed for them.

    Can't find a thing about this on any forum or msdn.

    Hope I'm explaining this at least somewhat clearly.

    Thanks.

  2. #2
    Board Regular jim may's Avatar
    Join Date
    Jul 2004
    Location
    Roanoke, VA
    Posts
    7,309
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Value of active cell to appear in different cell

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Range("R4").Value = Target
    End Sub
    To display your spreadsheet data use either MrExcel HTML Maker or Excel Jeanie

  3. #3
    New Member
    Join Date
    Sep 2009
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Value of active cell to appear in different cell

    worked like a champ. thank you very much.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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