Hello -
I have a workbook containing many modules that rely on a public constant. Currently, my public constant looks like this:
Public sEventName As String
Public Const VARDEST = "C:\Users\Tom\Desktop\Event History\"
What I need to do is this: instead of having VARDEST = an actual path, I want to assign the value of a worksheet cell to my Constant VARDEST. See my declarations below for a better understanding.
Please Login or Register to view this content.
A constant has to be just that Constant. Therefore you cannot assign it a value based on a cell.
A Const must have a value that is determined at compile time. You want to use an expression that must be evaluated at runtime, so you cannot use a Const. The only way to do what you want is this:
If you want VARDEST to be Public, it must be declared outside of a Sub. The two assignment statements here must be inside a Sub.Please Login or Register to view this content.
Note that the value of VARDEST will be calculated only at the point of this assignment statement. If the value of the cell changes later, the value of VARDEST will not.
Another way to do this is
Now VARDEST will always refer to that cell, and if the cell value changes, VARDEST will change.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks