i'll try to be brief: i want to create a 'settings' userform, which sets
some parameters (similar to using Tools Options in Excel's menu). for
example, using a check box to set whether to display another userform later
on.

my question is, can i use one piece of code (from a userform) to set a
variable in another code (making a permanent change, so if someone closes,
then re-opens the file, the setting remains)? and if so, how? how do i get
one piece of code to alter another?

many thanks for any help,

tim