Help on writing class module

[Guest]

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]

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.)

 

[NickHK]

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

 

[Guest]

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

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

 

[NickHK]

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

NickHK

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