using one macro to set a variable in another

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display variable in userform 5
How to get variables from worksheet code to userform code 6
Setting a variable for the userform itself? 3
Using a variable to select a CommandButton and setting the caption 4
Set Userform As A Variable 2
Defining public/global variables in more than one place 1
Question What determines if publlic variable content is destroyed 6
Userform textbox string to header causes unwanted double spacing 4

Back
Top