Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to store changing values from one cell
Hi,
I've been reading the posts and couldn't find what I needed. I have a cell that changes value every second (via DDE). I want to record the value of that cell in a column where each cell in the column represents the value for each second. There are two way I want to do this. The first is where the DDE value is stored in the column every second. When the last cell is written, the next write will be back to the top cell and everything get written over. The next way is to have the column shift the data down one position every second. The problem is, I don't want to do this with VB. I know, I know. It's unfortunate that because of the actions of some people, we hesitate to use a really useful feature. If no one can give answers to this. I'll post it in the "suggestions" for .... the next Excel upgrade? -- Emmie Villa |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to store changing values from one cell
The problem is, I don't want to do this with VB.
It's impossible to do without VBA (or some other language like C or C++) Biff "Emmie" wrote in message ... Hi, I've been reading the posts and couldn't find what I needed. I have a cell that changes value every second (via DDE). I want to record the value of that cell in a column where each cell in the column represents the value for each second. There are two way I want to do this. The first is where the DDE value is stored in the column every second. When the last cell is written, the next write will be back to the top cell and everything get written over. The next way is to have the column shift the data down one position every second. The problem is, I don't want to do this with VB. I know, I know. It's unfortunate that because of the actions of some people, we hesitate to use a really useful feature. If no one can give answers to this. I'll post it in the "suggestions" for ... the next Excel upgrade? -- Emmie Villa |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to store changing values from one cell
Even change via DDE should fire the sheet's _Change() event, right? And that
would make VBA coding pretty minimal, and very effective. "Biff" wrote: The problem is, I don't want to do this with VB. It's impossible to do without VBA (or some other language like C or C++) Biff "Emmie" wrote in message ... Hi, I've been reading the posts and couldn't find what I needed. I have a cell that changes value every second (via DDE). I want to record the value of that cell in a column where each cell in the column represents the value for each second. There are two way I want to do this. The first is where the DDE value is stored in the column every second. When the last cell is written, the next write will be back to the top cell and everything get written over. The next way is to have the column shift the data down one position every second. The problem is, I don't want to do this with VB. I know, I know. It's unfortunate that because of the actions of some people, we hesitate to use a really useful feature. If no one can give answers to this. I'll post it in the "suggestions" for ... the next Excel upgrade? -- Emmie Villa |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to store changing values from one cell
Thank guys. I was hoping that someone knew a way to do this without VBA.
Seems like a useful feature to have. -- Emmie Villa "JLatham" wrote: Even change via DDE should fire the sheet's _Change() event, right? And that would make VBA coding pretty minimal, and very effective. "Biff" wrote: The problem is, I don't want to do this with VB. It's impossible to do without VBA (or some other language like C or C++) Biff "Emmie" wrote in message ... Hi, I've been reading the posts and couldn't find what I needed. I have a cell that changes value every second (via DDE). I want to record the value of that cell in a column where each cell in the column represents the value for each second. There are two way I want to do this. The first is where the DDE value is stored in the column every second. When the last cell is written, the next write will be back to the top cell and everything get written over. The next way is to have the column shift the data down one position every second. The problem is, I don't want to do this with VB. I know, I know. It's unfortunate that because of the actions of some people, we hesitate to use a really useful feature. If no one can give answers to this. I'll post it in the "suggestions" for ... the next Excel upgrade? -- Emmie Villa |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to store changing values from one cell
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to store changing values from one cell
I am not sure it is impossible without code depending on what you are
willing to accept as a solution. Stephen Bullen has a sample file that you may find useful http://www.oaltd.co.uk/Excel/Default.htm Look at the Chrono.zip description It is the first item under the Worksheet Functions heading -- Regards, Tom Ogilvy "Emmie" wrote in message ... Thank guys. I was hoping that someone knew a way to do this without VBA. Seems like a useful feature to have. -- Emmie Villa "JLatham" wrote: Even change via DDE should fire the sheet's _Change() event, right? And that would make VBA coding pretty minimal, and very effective. "Biff" wrote: The problem is, I don't want to do this with VB. It's impossible to do without VBA (or some other language like C or C++) Biff "Emmie" wrote in message ... Hi, I've been reading the posts and couldn't find what I needed. I have a cell that changes value every second (via DDE). I want to record the value of that cell in a column where each cell in the column represents the value for each second. There are two way I want to do this. The first is where the DDE value is stored in the column every second. When the last cell is written, the next write will be back to the top cell and everything get written over. The next way is to have the column shift the data down one position every second. The problem is, I don't want to do this with VB. I know, I know. It's unfortunate that because of the actions of some people, we hesitate to use a really useful feature. If no one can give answers to this. I'll post it in the "suggestions" for ... the next Excel upgrade? -- Emmie Villa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing Linked Cell Values w/ Current Values | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
Changing values in a row based on a cell in the row. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |