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

Check out this link
http://www.cpearson.com/excel/vbe.htm

Mike F


"Tim" wrote in message
...
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

thanks Mike - looks like its just what i needed!

"Mike Fogleman" wrote in message
news:DS8Jc.71528$JR4.45303@attbi_s54...
Check out this link
http://www.cpearson.com/excel/vbe.htm

Mike F


"Tim" wrote in
message
...
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