Posted to microsoft.public.excel.programming

augustus

external usenet poster

Posts: 49

Help on writing class module

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CLASS MODULE & SIMPLE MODULE	FARAZ QURESHI	Excel Discussion (Misc queries)	1	September 7th 07 09:32 AM
let and get in class module	Doug Glancy	Excel Programming	3	June 30th 04 02:30 PM
Class module	Mark[_36_]	Excel Programming	2	February 17th 04 03:14 PM
Class module	David	Excel Programming	4	December 31st 03 01:58 PM
Variable from a sheet module in a class module in XL XP	hglamy[_2_]	Excel Programming	2	October 14th 03 05:48 PM

All times are GMT +1. The time now is 02:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us