Search results for query: *

HI, The queue doesn't have a fixed length. My buffer example has a fixed length of 3 positions. I guess i'll use queue and when the length is 4 i'll degueue one time. That makes the lenght 3 again. I was hoping there would be a similar thing as stack or queue. frank

hello, I would like to create buffer like the queue but then with a fixed length. So when the last value is added then the first added value drops out: position value 1 50 2 35 3 87 then value 29 is added and value 87 drops off: position value 1 29 2...

thats great thanks! frank

Hello, I'm looking for an excel layout for VB. So a spreadsheet lookalike or something. Does that exist? thanks frank

I was focusing on the worksheet_change event Target.Cells.Count is never more then 1 because the DLL writes the cells in Excel at nearly exactly the same time. It's really fast which is an advantage. So the first time the worksheet_change event is triggered and Sub sub_a(a) is called then 1...

Well, The program (a financial charting package) calls a dll which writes values to cells in Excel. Excel detects cell change and passes orders to another program to shoot orders to the stock exchange. frank

thank you very much for replying. (I noticed that the code above works fine. I doesnt miss any updates and the logfile is written everytime there is an update.) I'l try to be more clear. 1. A program writes values in the range d3:e40 really fast 2. It can be 1 cell or upto 38 at the (nearly)...

hello, Whats the maximum nr of Worksheet_Change events per second/millisecond? I have a program which put data in Excel cells. I try to catch them all with Worksheet_Change. like this: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("d3:e40")) Is Nothing Then...