Public Variables

These are the public variables which might be referenced in my vba code examples.

    General
    Public startTime As Double
    Public starttimeX As Double
    Public Const myerrors As Boolean = False 	'or True
    Public Const showtimer As Boolean = True 	'or False
    Public Const myerrorlog As Boolean = True	'or False 
    Public mylc As Long
    Public mylr As Long
    Public mylca As String
    Public mymsg As String
    Public myprompt As String
    Public calcmode As Long
    Public PwdEntered As String
    Public sMaskedPwdCaption As String
    Public bEXITALL As Boolean
    Public MOD_NAME As String
    Public Const MyPwd As String = "Adm1n"                                             '<< Input box password
    Public Const MyWorksheetPwd As String = ""                                       	'<< Worksheet password, a blank string is used as it speeds up processing, BUT you need to do the 'Ribbon' amendment!
    Number variables are based on the 'Accounting' format
    Public MyNumberFormat As String                                                 	'<< Variable to hold assignable number format
    Public Const W_Number_0 As String = "_(* #,##0_);_(* (#,##0);_(* ""-""_);_(@_)"           	'<< W - Whole number format, 0 decimals
    Public Const W_Number_2 As String = "_(* #,##0.00_);_(* (#,##0.00);_(* ""-""_);_(@_)"      	'<< W - Whole number format, 2 decimals
    Public Const K_Number_0 As String = "_(* #,##0,_);_(* (#,##0,);_(* ""-""_);_(@_)"         	'<< K - Thousand's number format, 0 decimals"
    Public Const M_Number_2 As String = "_(* #,##0.00,,_);_(* (#,##0.00,,);_(* ""-""_);_(@_)"   	'<< M - Million's number format, 2 decimals