Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Make a changing cell visible while still running

I now suspect that it is simply a timing problem -- if you try to
update a cell too quickly in succession, it does not change at all.
Does that ring a bell? It's easy enough to test.

As for progress indicators, let me assure you that what I am doing
makes some sense. The user picks a subset of lines from about 40 on the
screen, and then hits "go" (presently a double-click on a cell, but
could be a dialog). The system then process a bunch of files
associated with each chosen line.

So, rather than a single, anonymous progress bar where you really have
no idea what is actually happening, I thought it would be nice to show
progress for each line's files *on that line* -- like "finding files
for line 3", "processing file 3.01", "processing file 3.02", etc, "Done
with 74 files for 3", then go on the "finding files for line 7" etc,
where the progress indicators would appear on the relevant lines of the
spreadsheet, right next to each selection.

Anyway, I got it working. Thanks for the good discussion on the topic.
I learned some things, even if they didn't solve the problem at hand.
If I check out the timing issue, I'll start a new thread.

Thanks. --David.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I make a running total change in a new cell Meenie Excel Worksheet Functions 3 April 7th 08 07:48 PM
How to make visible all text in cell with word wrap on Al Excel Discussion (Misc queries) 0 September 18th 07 05:20 PM
How to make sure a Cell is within the current visible window's ran OKLover[_2_] Excel Programming 2 July 13th 05 01:38 PM
Running a macro by changing a cell value Dave[_54_] Excel Programming 1 March 21st 05 05:58 AM
How can I make the bar that shows the content of the cell visible. ZG Excel Discussion (Misc queries) 1 January 8th 05 07:27 PM


All times are GMT +1. The time now is 09:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"