View original (French)

Keep cell values in memory

Solved
lalalafouine Posted messages 13 Status Member -  
 Rondoudou8 -
Hello,

I am currently working on a program that is half VBA and half Excel, and I would like to keep the values of certain cells after each increment.
In other words, I have cell values that will change with each increment, but I would like to retain them on the Excel sheet so that I can integrate them into a graph later.
Is there a function that allows this, or do I need to create a macro or a line of VBA code?
Thank you in advance
Configuration: Windows Vista Opera 9.62

2 answers

  1.
    lalalafouine Posted messages 13 Status Member 2
     
    Hello Michel,

    Thank you for your response, but I am a VBA beginner, so what you are telling me doesn't ring a bell at all!
    My problem is that, for example, the cell A22 keeps changing its value as I increment, and I would like to keep a specific value from A22 when, for example, the cell B13 changes value (for example, B13 changes from 0 to 1). I would need a logical test in Excel (e.g., as soon as B13=1, then keep the value of A22). So how can I save the value in A22 that keeps changing all the time? And preferably, a solution in Excel, not VBA!
    Thanks again.
    1
    1. Rondoudou8
       
      try --> indirect() or logical tests like if()...
      0
  2. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello,

    well with your increment (cptr) you add a line

    cells(cptr,1)=tavaleur registers the value in the line of the increment counter, column A (A --->1)
    --
    Best regards,
    Michel
    0