Help with variable declarations

[KGee]

I have a macro which runs and loads a user form towards the end of the routine. There is a variable which gets set before the form is displayed which then shows up as empty when the user form is loaded. When the user form is unloaded and the macro resumes, I can see the variable once again has the value assigned. What do I need to change to make the variable stick while the user form is displayed? I am trying to use it while the user form is displayed to the user.

 

[Norie]

How have you got it declared now and where/when/how are you giving it a value?

 

[KGee]

Hi Norie,

I have it declared "above" the module in the General/Declarations section. There are three separate subroutines in the module, a primary and two secondary. There is a T/F check in the primary which determines which of the secondary routines is called and that is where the variable gets set. It is used both in the secondary sub and when processing returns to the primary sub.

I have tried with it set as Dim varname As String and also Public varname As String, both in the General/Declarations section.

I double-checked to make sure it is only declared one time. I have also double-checked to make sure it is only set one time. I have basically the same setup in two other files but it doesn't work with this new file.

 

[Norie]

Have you considered not using public variables for this?

I think I might have actually suggested that before.

What exactly are you using this variable for?

You mention it gets some sort of check in a 'primary sub' then it's used in another sub.

Have you considered that it might be getting changed in the sub that's called?