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