I have a command button that when clicked runs a VB script that carries out a
complex calculation. Right now, the caption for the button reads,
"Calculate".

I'd like it to switch to read, "Working" while it is doing the calculating
and then back to "Calculate" when it's done.

If I enter Me.CommandButton1.Caption = "Working" at the beginning of the
script, it doesn't change. Probably not refreshing.

Is there a way to get it to change while it's calculating?

Thanks in advance.

Jerry