View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Basic question - modules and class modules - what's the difference?

<The overwhelming majority of workbooks in the wild don't even contain a
*formula*!

LOL-True!
In the company I used to work for, a staff share option scheme was
announced.
A colleague of mine issued a spreadsheet with which you could calculate your
possible profits under varying circumstances.
There appeared to be no formula at all; it was just a template that could
have been a paper one as well. Turned out that the colleague who had been
using Excel for years already (working in a budgeting department) wasn't
aware you could automate the calculations using formulas! Spreadsheet: paper
with a columns and rows layout.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel


"JE McGimpsey" wrote in message
...
Personally, I'd stick with deko's analysis, since he said "most people".

I'd guess that the fraction of users of XL that have ever used a
non-standard object is less than 1%, and the fraction who've actually
created a "business function object" infinitesimally smaller.

The overwhelming majority of workbooks in the wild don't even contain a
*formula*!




In article ,
"Bob Phillips" wrote:

Excel provides all the
objects most people need, so rarely will you need to create you own
class
modules.


That's not true Deko. Excel provides most of the Excel objects, methods
and
properties that we need (not all!), but they provide not business
function
objects, so we need to create those. Class modules are ideal for that.