Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    May 2001
    Berkeley, California, USA
    Thanked 0 Times in 0 Posts

    function to enter value (EXcell 2000)

    Is there a function that will enter the value of one cell into another cell.
    For example if I have a formula in A1 and I want the value of that formula in C1 is there a function that will do that.
    In other words I want C1 to be as if I copied A1 Paste Special/Value to C1. I do not want to have a formula in C1.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: function to enter value (EXcell 2000)

    You could use the Worksheet_Calculate event:
    - Activate the Visual Basic Editor (Alt+F11).
    - Double click the appropriate worksheet node in the Project Explorer.
    - Copy the following code into the worksheet module:

    Private Sub Worksheet_Calculate()
    Application.EnableEvents = False
    Range("C1").Value = Range("A1").Value
    Application.EnableEvents = True
    End Sub

    Don't try to do too much in the Worksheet_Calculate event, for it will fire for EACH recalculation of the worksheet.

Posting Permissions

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