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