use input box variable in more than one module / procedure

[Shadow123]

Ok i know i have done this before but im totally blanking. I want to user the inputvalue in procedures called from controller, but it just shows as empty.

What am i doing wrong?

Sub controler()
Static inputvalue As Long
inputvalue = InputBox("Please set min size of trades.")
'other macro's called here
end sub

 

[Shadow123]

i need to use this result in about 10 macros in lots of modules... im just calling them by putting

call mynextmacro

and so on

 

[Andrew Poulsom]

Does it really need to be static? If not declare it as Public at the top of your module and nowhere else.

 

[Shadow123]

I just need an input box to pop up ... and keep that value.

I tried

Option Explicit
Public inputvalue As Long


Public Sub controler()
inputvalue = InputBox("Please set min size of trades.")

call macro1
end sub

but once i get into macro1, the variable is gone... im not sure what im doing wrong. do i need Sub macro1(inputvalue) ? or is sub macro1 enough

 

[Shadow123]

Even this, as a test doesn't work

Public inputvalue As Long
Sub testing()
inputvalue = InputBox("Please enter value")
Debug.Print inputvalue
Call messageformat
End Sub
 
Sub messageformat()
MsgBox (inputvaluve)
End Sub

The debug print result was
100

Its available until it calls the next procedure then poof... gone