Updating Information on Userform VBA
 

Hi all,

Just wondering how I could update information automatically on a userform. I
want to display a form which will display the information from a spread
sheet. Then after a minute I would want it to update automatically.
Is this possible? I have been using the mouse movement command but that is
not quite what I would need.

Thank you
Greg

Updating Information on Userform VBA
 

I have an idea, but it might not be what you're looking for...

How about just update your userform the very instant
that ANYTHING is changed on your spreadsheet?

In other words, put code in "Worksheet_Change" that
updates your userform (or not) whenever a change occurs
on your spreadsheet. Will that work?



"Greg Brow" wrote in message
...
Hi all,

Just wondering how I could update information automatically on a userform.
I want to display a form which will display the information from a spread
sheet. Then after a minute I would want it to update automatically.
Is this possible? I have been using the mouse movement command but that is
not quite what I would need.

Thank you
Greg

Updating Information on Userform VBA
 

Yes thank you Robert,
I was looking far too deep for the answer. Sometimes it is much easier than
one thinks.

Thanks again.
Greg

"Robert Crandal" wrote in message
...

I have an idea, but it might not be what you're looking for...

How about just update your userform the very instant
that ANYTHING is changed on your spreadsheet?

In other words, put code in "Worksheet_Change" that
updates your userform (or not) whenever a change occurs
on your spreadsheet. Will that work?



"Greg Brow" wrote in message
...
Hi all,

Just wondering how I could update information automatically on a userform.
I want to display a form which will display the information from a spread
sheet. Then after a minute I would want it to update automatically.
Is this possible? I have been using the mouse movement command but that is
not quite what I would need.

Thank you
Greg

Updating Information on Userform VBA
 

Greg

For best results OnTime code would be the way to go.

See Chip's site for code and instructions.

http://www.cpearson.com/excel/OnTime.aspx


Gord Dibben MS Excel MVP

On Sun, 2 Jan 2011 01:51:21 +1030, "Greg Brow"
wrote:

Yes thank you Robert,
I was looking far too deep for the answer. Sometimes it is much easier than
one thinks.

Thanks again.
Greg

"Robert Crandal" wrote in message
m...

I have an idea, but it might not be what you're looking for...

How about just update your userform the very instant
that ANYTHING is changed on your spreadsheet?

In other words, put code in "Worksheet_Change" that
updates your userform (or not) whenever a change occurs
on your spreadsheet. Will that work?



"Greg Brow" wrote in message
...
Hi all,

Just wondering how I could update information automatically on a userform.
I want to display a form which will display the information from a spread
sheet. Then after a minute I would want it to update automatically.
Is this possible? I have been using the mouse movement command but that is
not quite what I would need.

Thank you
Greg