Store a value to the users registry (VBA).

     SaveSetting appname:="AppName", Section:="Section", Key:="Key", setting:="Setting"

     SaveSetting "AppName", "Section", "Key", "Setting"
   AppName  The name of the application or project.

Section The name of the section in which the key setting is being saved.
Key The name of the key setting being saved.
Setting The value to which Key is being set (string or number).

All the registry entries will appear under HKEY_CURRENT_USER\Software\VB and VBA Program Settings\


Save a registry key named "LastOrderViewed" with a value of "1375", placing it under the key named "SS64", and a sub key named "DemoDB" (create the keys if they don't already exist):

SaveSetting appname:="SS64", Section:="DemoDB", Key:="LastOrderViewed", setting:=1375

“If you stuff yourself full of poems, essays, plays, stories, novels, films, comic strips, magazines, music, you automatically explode every morning like old faithful. I have never had a dry spell in my life, mainly because I feed myself well, to the point of bursting. I wake early and hear my morning voices leaping around in my head like jumping beans. I get out of bed to trap them before they escape” ~ Ray Bradbury


DeleteSetting - Delete a value from the users registry
GetSetting - Retrieve a value from the users registry
GetAllSettings - List the keys and values saved in the registry

Copyright © 1999-2024
Some rights reserved