Sulprobil
Search…
Welcome to my Web Pages
Access
Excel
Best Practice
VBA
Introduction
Classes
Logging
SystemState
Accounts Receivable Problem
Cholesky
Combinatorial Fun
Error Trapping
Game of Risk
Iman Conover
IsOpen
List Frequencies
Lookup Variants
PF_Allocate
Redw
Regular Expressions
Rww
sbAccumulatedTradeBlotter
sbAverageLast
sbBirthdayList
sbCat
sbCellWatermarks
sbCompareTwoLists
sbContainsAllChars
sbCountUniq
sbCountVisible
sbDataStats
sbDHondt
sbDistBudget
sbExactRandHistogrm
sbExactRandInt
sbExportRange2Picture
sbGenerateTestData
sbGenNormDist
sbGetCell
sbGrowthSeries
sbGSort
sbHighlightMinAdjacentCellsWhichSumUpToP
sbInterp
sbListAssetWeightCombinations
sbLockedFormula
sbLongDec2Bin
sbLongRandSumN
sbMatchCheck
sbMostFrequentPairs
sbNextFloat
sbNoBlank
sbNRN
sbNSig
sbNum2Str
sbORB
sbRandCauchy
sbRandCDFInv
sbRandCumulative
sbRandGeneral
sbRandHistogrm
sbRandInt
sbRandIntFixSum
sbRandomNoRepatBeforeN
sbRandPDF
sbRandSum1
sbRandTriang
sbRandTrigen
sbRebalancedReturn
sbReShape
sbRLess
sbRndDecPlace
sbRoundRobin
sbRoundToSum
sbSpellNumber
sbSplit
sbSumLast
sbSumMyFormat
sbSWV
sbTaskList
sbTeamGolf
sbTimeAdd
sbTimeDiff
sbVector
sbZip
Set last month on X axis to report month
UniqRandInt
Weekday Day of Month
Weekday in Month
Worksheet Functions
Perl
SQL
Word
Business Development
Human Resources
Information Technology
Organisation
Risk Management
Contact
Disclaimer
Impressum
Powered By
GitBook
Classes
With VBA class modules we can create our own reusable objects.
A good introduction into VBA classes you can find at
Chip Pearson's website
.
During my 30 years of Excel practice I have encountered some very useful classes which I like to present here:
​
SystemState
- This one I am using in almost all of my serious VBA applications to speed up my code.
​
Logging
- This class is very useful if you like to document each execution (run) of your VBA code.
​
​
​
Previous
Sample Application
Next
Logging
Last modified
2mo ago
Copy link