| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable that keeps its value until reset
Hi,
How can I declare a variable that will keep its value not only after a procedure is run, but when Excel or the computer is shut down--that will keep its value until it is reset? THanks, Jamie |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
variable that keeps its value until reset
Jamie,
You would have to store it in the registry or write it to a text file. Have a look at help on SaveSetting and GetSetting. Robin Hammond www.enhanceddatasystems.com Check out our XspandXL add-in "Jamie Martin" wrote in message ... Hi, How can I declare a variable that will keep its value not only after a procedure is run, but when Excel or the computer is shut down--that will keep its value until it is reset? THanks, Jamie |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
variable that keeps its value until reset
The place you might be thinking of storing your variable
might be within your VBA code. This can be done and it might best be stored in a little two line routine that can be called as required. Self modifying code is possible but you will have to search the internet or MS Knowledgebase for a good lead. -----Original Message----- Jamie, You would have to store it in the registry or write it to a text file. Have a look at help on SaveSetting and GetSetting. Robin Hammond www.enhanceddatasystems.com Check out our XspandXL add-in "Jamie Martin" wrote in message ... Hi, How can I declare a variable that will keep its value not only after a procedure is run, but when Excel or the computer is shut down--that will keep its value until it is reset? THanks, Jamie . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Runtime Error '91' Object variable or With block variable not set | Excel Discussion (Misc queries) | |||
| "Too Many Cell Formats" Got Fix! But ... need VBA Variable reset | Excel Discussion (Misc queries) | |||
| variable height variable width stacked bar charts | Charts and Charting in Excel | |||
| Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
![Jamie Martin[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
