Is there a way I can use the value of a global variable, e.g., the global variable Chapter

Option Explicit

Public Date_Member_Rpt As Date
Public Chapter As String
Public Changed_Input_CSV_File As Boolean
Public Changed_Input_Attendance As Boolean
in a formula that appears in one of the cells of one of my worksheets? I can access the value of these variables in any procedure or function in any worksheet, but I don't see how to access the variables' values in my formulas in cells.


I currently have working VBA code that assigns a value to the cell of a worksheet. As long as I fully reference the cell, any formulas in any spreadsheet can read the value of a cell that was assigned its value by a VBA assignment.
The problem with this implementation is remembering what the various cells' meanings are. If I could replace storing a value from VBA in a cell (and using the cell's value in the cell in formulas) with storing values in a variable in VBA (and using the variable's value in formulas in cells), I could name the variables in a way that makes
my code much more mnemonic and much easier to read.