Hi,

I don't know anything about class module, but I think I know what I want to
do will need to be done in class module since it is an Application level
function.

I want to show a MsgBox whenever Application.CalculationState < xlDone, so
that user of the spreadsheet is aware of the calculation state. Since most
people hide the status bar to increase view area.

Thanks
Augustus

Chip Pearson has a bunch of notes for application events at:

http://www.cpearson.com/excel/AppEvent.htm

At the bottom of that page, there's a link to download a sample workbook. Don't
miss that.

Personally, I never hide the statusbar. (I would find the message box very
irritating when calculation is set to automatic and I'm changing formulas.)



augustus wrote:

Hi,

I don't know anything about class module, but I think I know what I want to
do will need to be done in class module since it is an Application level
function.

I want to show a MsgBox whenever Application.CalculationState < xlDone, so
that user of the spreadsheet is aware of the calculation state. Since most
people hide the status bar to increase view area.

Thanks
Augustus

--

Dave Peterson

augustus,
I agree with Dave. If I had to continually click a MsgBox, I would
immediately drop the product.
You could test to see if the Status bar is visible and then show 1 msgbox to
indicate to the user that your app will not work as designed. Give them the
option that you show it or not.

NickHK

"Dave Peterson" wrote in message
...
Chip Pearson has a bunch of notes for application events at:

http://www.cpearson.com/excel/AppEvent.htm

At the bottom of that page, there's a link to download a sample workbook.
Don't
miss that.

Personally, I never hide the statusbar. (I would find the message box
very
irritating when calculation is set to automatic and I'm changing
formulas.)



augustus wrote:

Hi,

I don't know anything about class module, but I think I know what I want
to
do will need to be done in class module since it is an Application level
function.

I want to show a MsgBox whenever Application.CalculationState < xlDone,
so
that user of the spreadsheet is aware of the calculation state. Since
most
people hide the status bar to increase view area.

Thanks
Augustus

--

Dave Peterson

Thanks Dave Peterson and NickHK.

I forgot about when someone change a cell would also trigger calculation.
Is there way to prevent user from doing anything while
Application.Calculation<xlDone, becuase people tend to be very impatience?

Thanks
Augustus

"NickHK" wrote:

augustus,
I agree with Dave. If I had to continually click a MsgBox, I would
immediately drop the product.
You could test to see if the Status bar is visible and then show 1 msgbox to
indicate to the user that your app will not work as designed. Give them the
option that you show it or not.

NickHK

"Dave Peterson" wrote in message
...
Chip Pearson has a bunch of notes for application events at:

http://www.cpearson.com/excel/AppEvent.htm

At the bottom of that page, there's a link to download a sample workbook.
Don't
miss that.

Personally, I never hide the statusbar. (I would find the message box
very
irritating when calculation is set to automatic and I'm changing
formulas.)



augustus wrote:

Hi,

I don't know anything about class module, but I think I know what I want
to
do will need to be done in class module since it is an Application level
function.

I want to show a MsgBox whenever Application.CalculationState < xlDone,
so
that user of the spreadsheet is aware of the calculation state. Since
most
people hide the status bar to increase view area.

Thanks
Augustus

--

Dave Peterson

augustus,
Do you have a work sheet that takes a long time to recalculate ?
You could switch to manual calculation.

NickHK


"augustus" wrote in message
...
Thanks Dave Peterson and NickHK.

I forgot about when someone change a cell would also trigger calculation.
Is there way to prevent user from doing anything while
Application.Calculation<xlDone, becuase people tend to be very
impatience?

Thanks
Augustus

"NickHK" wrote:

augustus,
I agree with Dave. If I had to continually click a MsgBox, I would
immediately drop the product.
You could test to see if the Status bar is visible and then show 1
msgbox to
indicate to the user that your app will not work as designed. Give them
the
option that you show it or not.

NickHK

"Dave Peterson" wrote in message
...
Chip Pearson has a bunch of notes for application events at:

http://www.cpearson.com/excel/AppEvent.htm

At the bottom of that page, there's a link to download a sample
workbook.
Don't
miss that.

Personally, I never hide the statusbar. (I would find the message box
very
irritating when calculation is set to automatic and I'm changing
formulas.)



augustus wrote:

Hi,

I don't know anything about class module, but I think I know what I
want
to
do will need to be done in class module since it is an Application
level
function.

I want to show a MsgBox whenever Application.CalculationState <
xlDone,
so
that user of the spreadsheet is aware of the calculation state.
Since
most
people hide the status bar to increase view area.

Thanks
Augustus

--

Dave Peterson