Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Type and Speed in Updateing Status Bar
I have a simple text Status Bar which which shows the results of a search I
am doing through all the cells in a column (1 to 65536). I am using the Application.StatusBar = Range.Address. I effectiely show in the status bar what cell I am in while looping (A1, A2, A3 etc). As you can imagine the status bar updates frequently (every time I advance to a new cell in the column). I have noticed that the statusbar updates starts fast at first and then gradually slows down. It then crawls at a snails pace to reach 65536. I am Dimensioning my variable as a Double. Why does it start fast and then slow down over time as it approaches 65536. Can I dimension the variable differently or is this simply the reality of hava statusbar update that frequently? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Type and Speed in Updateing Status Bar
What code do you use?
-- Kind regards, Niek Otten Microsoft MVP - Excel "ExcelMonkey" wrote in message ... I have a simple text Status Bar which which shows the results of a search I am doing through all the cells in a column (1 to 65536). I am using the Application.StatusBar = Range.Address. I effectiely show in the status bar what cell I am in while looping (A1, A2, A3 etc). As you can imagine the status bar updates frequently (every time I advance to a new cell in the column). I have noticed that the statusbar updates starts fast at first and then gradually slows down. It then crawls at a snails pace to reach 65536. I am Dimensioning my variable as a Double. Why does it start fast and then slow down over time as it approaches 65536. Can I dimension the variable differently or is this simply the reality of hava statusbar update that frequently? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Type and Speed in Updateing Status Bar
I had more or less the same issue, but I blame it on the memory
managament of my code, not on updating the statusbar. DM Unseen |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Type and Speed in Updateing Status Bar
Well that was my next question. I have also noticed that if I run the
routine alot of times it actually gets to the point where it starts off slow too. That is, the more I run it, the more it seems that something is holding it back. What can I do in terms of my systems memory managment? Thanks "DM Unseen" wrote: I had more or less the same issue, but I blame it on the memory managament of my code, not on updating the statusbar. DM Unseen |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Type and Speed in Updateing Status Bar
I just repeat my question; What code do you use?
-- Kind regards, Niek Otten Microsoft MVP - Excel "ExcelMonkey" wrote in message ... Well that was my next question. I have also noticed that if I run the routine alot of times it actually gets to the point where it starts off slow too. That is, the more I run it, the more it seems that something is holding it back. What can I do in terms of my systems memory managment? Thanks "DM Unseen" wrote: I had more or less the same issue, but I blame it on the memory managament of my code, not on updating the statusbar. DM Unseen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updateing formulas | Excel Worksheet Functions | |||
What data type for Variable? | Excel Programming | |||
Trouble with variable type | Excel Programming | |||
type variable as argument of a sub | Excel Programming | |||
Variable Type - help me to solve this | Excel Programming |