move variable to next user form

[Arie Bos]

Hello Excel Masters...

I have a userform A in which a value is entered in a textbox.
Then, a button opens up another user form B where I would like to show that value again in a new textbox in grey, so the user knows this is a copied value, but he should still be able to change it for the next round of calculations.
As this value on user form A is not part of a specific procedure that I could make public, I am not sure how to retrieve that specific value in user form B..

What is the correct procedure to do this?

Many thanks,

 

[richh]

Declare a global variable that holds the value.

 

[Arie Bos]

Hi Richh,

I put it as follows:
in user form A:

Option Explicit
    Public SSDOperatingDays As Integer

in user form B

Option Explicit
Private Sub UserForm_Initialize()
    txtN_SSDOperatingDays.Value = SSDOperatingDays

after opening user form B from a commandbutton on A, error return "Variable not defined", with SSDOperatingDays marked blue

Is this a syntax issue?

 

[richh]

I believe that the variable should be declared in a module.

 

[Arie Bos]

Hi Richh,

Yes, I found out, and it works, thanks to your suggestion!