Hi all,

I'm trying to write a macro that gets the length of an active cell and
then shows that value in real time, in a set location (like a little
box in the toolbar).

I've got the first part down, but I'm having trouble getting the output
part of it down. Anyone have a suggestion on what the easiest way to go
about this would be?

Thanks.


--
jgoog
------------------------------------------------------------------------
jgoog's Profile: http://www.excelforum.com/member.php...o&userid=33618
View this thread: http://www.excelforum.com/showthread...hreadid=533948

You can use the OnTime method of the Application object to run a
macro at a specified interval. See
www.cpearson.com/excel/ontime.htm for details and example code.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"jgoog"
wrote in message
...

Hi all,

I'm trying to write a macro that gets the length of an active
cell and
then shows that value in real time, in a set location (like a
little
box in the toolbar).

I've got the first part down, but I'm having trouble getting
the output
part of it down. Anyone have a suggestion on what the easiest
way to go
about this would be?

Thanks.


--
jgoog
------------------------------------------------------------------------
jgoog's Profile:
http://www.excelforum.com/member.php...o&userid=33618
View this thread:
http://www.excelforum.com/showthread...hreadid=533948