Basically as follows

One workbook with a dialog sheet named "SetUp" opens 2 other workbooks of
data and compares them.

As the VBA code cycles through it places the current record progress (
1of2000, 2of2000,3of3000 etc) on a cell location within sheet 1 , lets say
cell reference A1.

On the Dialog Sheet "SetUp" I have inserted a text box and within it I
entered =Sheet!1A1 , something like that.

If I type "Progess 1 of 2" in cell A1,no code running no dialog active,the
info is changed on the Dialog Sheet when I view it (not run it), so far so
good.

But if the Dialog is Activated and the Macro is cycling through, the Dialog
Sheet text box is not updating. I know the cell is updating because I
dragged the dialog box out the way so I can see the VBA cycling through the
records ( 1of2000, 2of2000,3of3000 etc).

I have even tried writing directly to the text box with
DialogSheets("SetUp").textboxes("txtProgess").text ="Progress 1 of xxxx"

But the text box is still not being updated with a new value.

What do I need to do , to get this text box on my dialog sheet to update as
cell A1 updates, I dont remember having this problem in earlier versions of
Excel.

Current version is Excel 2K

thanks

Macroman