[RESOLVED] Show an egg timer

I have a FlexGrid with a load of records in it - the user can click on the column headings to re-sort the grid but it takes a few seconds to execute.

I am using

.redraw = False and .redraw = True ....

How can I get an egg-timer to appear between .redraw = False and True?

Thanks for any help.

I don't believe I've ever heard of it referred to as an Egg Timer before. :lol:

Try

Code:

---

Screen.MousePointer = vbHourGlass

---

Code:

---

Screen.MousePointer = vbHourGlass
DoEvents
.redraw = False
'do your stuff
.redraw = True
Screen.MousePointer = vbDefault
DoEvents

---

Quote:

---

Originally Posted by Hack

I don't believe I've ever heard of it referred to as an Egg Timer before. :lol:

Try

Code:

---

Screen.MousePointer = vbHourGlass

---

---

Must be a British thing!

Thanks for the answer and to others who replied too.